View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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