阅读背景:

在“使用VBA返回Excel功能区”时获取editbox值

来源:互联网 

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.My first question here. I'm trying to add a cus




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: