Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combo box with data to use as hyperlinks
I have a large work sheet and need to link to several different ranges (52
ranges 1 for each week of the year) from the each of the same ranges. My thought is a combo box labelled 'Go to Week no.' that i can list the 52 ranges e.g week1 week2 etc. and once selected it will create a hyperlink to that specific range, i'd prefer the combo box rather than data validation as you can increase the number of rows in the combo box (unlike the data validation box) which means less scolling for selecting the link. I can hopefully copy the combo box and paste in into several areas on the work sheet? Any suggestion would be appreciated. The named ranges in the name box on the formula bar was one option, though i already have around 70 links in there from another sheet so i'd rather not increase this list! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ranking query | Excel Discussion (Misc queries) | |||
Combo Boxes for data entry | Excel Worksheet Functions | |||
Hyperlinks and sorting data | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
data val. and combo box | Excel Discussion (Misc queries) |