Incremental search to find worksheets

[sundarvenkata]

Hi All,

I have this unique requirement of implementing incremental search to
go to a specific worksheet within a workbook. I want this
functionality to be present for any excel worksheet that I open. I
want to be able to popup a dialog box with a text field where I enter
the name of the worksheet and I should be able to reach the worksheet
that I type. Is it possible to do this with Excel VBA?

Thanks in advance,
Sundar

 

[Mike H]

Excel has that built in to it. Right click the Fast forward/reverse buttons
to the left of Sheet1 tab and you get a popup of all your sheets which you
can click and go to.

Mike

 

[sundarvenkata]

I do not want to use my mouse to reach a particular worksheet. That is
the whole purpose of this argument.

Anyway I implemented this as an add-in. This can be found in my blog.

However I still have a small problem. I have made the dialog box to
appear when I press Ctrl+Shift+I and it should disappear when I press
the Escape key. However I am not able to remove the dialog the first
time I am invoking it in any worksheet. The dialog box, however,
disappears on pressing Escape key for the second and subsequent times.
Is this a bug or am I missing something?. Any insights into this?