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 |
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 |
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? |
All times are GMT +1. The time now is 06:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com