Dear Rick Rothstein

Thanks for your reply.
That is one way of doing it. I apologised for not making things clear
initially.

Actually, I am trying to create something with an "auto complete" function
on a single cells to search for the tabs name.

Eg,
Sheet1=Search menu
Sheet2=John
Sheet3=Donald
Sheet4=Don
Sheet5=Bill & etc

Once I type something like "do" on a cell on the Search Menu(Sheet1), it
will lookup and filter, leaving Donald & Don in the selection list.
Thereafter, when I choose "don" on that cell, it will bring me to Sheet4(Don).

Thanks

Alvyn


"Rick Rothstein (MVP - VB)" wrote:

Are you doing this strictly to be taken to the desired worksheet? If so,
would right clicking on the tab navigation toolbar (the 4 VCR looking
buttons to the left of the tabs) and selecting the worksheet from the list
box that appears be an acceptable solution?

Rick


"Alvyn" wrote in message
...
Dear Sir/Mdm,

Can anyone please advice how to search for a specific worksheet tab based
on
a cell value (user input) on a worksheet.

Eg, I have 50 worksheets in 1 workbook.
Sheet1=Main Menu
Sheet2=Customer ID 1
Sheet3=Customer ID 2
Sheet4=Customer ID 3 and etc.

If I input a value say "Customer ID 45" in a cell in Main Menu (Sheet 1),
how can Excel "intelligently" brings me to Sheet 46 which is also Customer
ID
45?

Thank you

Alvyn