LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Find text and open hyperlink

I have a spreadsheet with about 30 worksheets in it. I use the first page as
a "directory" where the names of the worksheets are listed. Each name of the
worksheet has a hyperlink to take the user to the appropriate worksheet. The
sheets on the directory are in a particular (but not alphabetic) order.

I would like to have a combo box (unless there is a better suggestion) where
I could do a quick search. I would like for it to auto complete what I type
in and then go to the correct worksheet. Any suggestions?

Thanks for any help!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
slide vertical text? linking to 1rst row in the screen? open in the last edited row? BLopes Excel Discussion (Misc queries) 3 June 26th 06 11:38 AM
Error message when using Excel to open text file orutulsa Excel Discussion (Misc queries) 2 March 14th 06 06:10 PM
Hyperlink won't open any other XLS file Jinx1966 Excel Discussion (Misc queries) 2 February 9th 06 08:26 AM
Find and replace should work in Excel text boxes Bob@Teton Excel Discussion (Misc queries) 0 October 20th 05 01:16 PM
text files open with all data in first column Eileen Excel Discussion (Misc queries) 1 May 10th 05 05:01 PM


All times are GMT +1. The time now is 12:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"