Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Incremental search to find worksheets
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Incremental search to find worksheets
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" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Incremental search to find worksheets
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search all worksheets | Excel Programming | |||
Search all worksheets | Excel Programming | |||
#N/A search across multiple worksheets. | Excel Programming | |||
search a string withing a string : find / search hangs | Excel Programming | |||
search worksheets | Excel Discussion (Misc queries) |