title: Get editbox value on "Return in Excel ribbon with VBA
body: <p>My first question here.
  I'm trying to add a custom search field in Excel ribbon. My problem with the usual research : its default range is "this worksheet" whereas I'd want the whole Workbook (or even other known workbooks).
  So I created an editbox in the ribbon. I use "onChange" to validate my input and trigger my custom research sub.
  But I'd prefer it to be triggered only when I press "Enter" key on my keyboard, or give focus to another ribbon button (a button "search" wich would trigger the research sub with my editbox value, and wich would be activated when pressing Return while focus is still on editbox.</p>
  
  <p>My other problem is that leaving the field also triggers the sub (onChange is activated when leaving) ; it doesn't trigger the event if editbox has not been changed ; and I can't catch the "Enter pressed" action.</p>
  
  <p>Are there ways to solve what I'm trying to do ?
  If not, is there a way to call the native search function with "workbook" range as default range, instead of "this worksheet"?</p>
  
  <p>Thank you for help.</p>
  
  <p>JP</p>