Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel - Triggering hyperlinks from a list box

Status
Not open for further replies.

beanxx

Technical User
Jul 9, 2002
61
GB
Is it possible to trigger hyperlink to other pages within the same workbook by picking values from within a list box. For example clicking on Page 1 from within the List Box will jump to Page 1, clicking on Page 2 will jump to Page 2, etc.

Thanks,

Justin
 
From Excel Help:

You cannot create a hyperlink from a control created by using the Forms toolbar or from a button or graphic that has a macro attached to it.


I would Create an area on the worksheet and creat the hyperlinks there. You can box it in and color it as you please.

Blue
 
Blue,

Thanks for that. I wasn't sure if it was possible but I guess using boxes will have to do.

Thanks,

Justin
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top