Anyone got an example of how to use a combo box to select hyperlinks to take you off to the selected website? I have this, which works but it's hard-coded - I'm looking for something a little more dynamic, i.e. pick up hyperlinks from a range on a sheet.
Please Login or Register to view this content.
Hello reddwarf,
The attached workbook contains a list of hyperlinks that are loaded into a ComboBox on worksheet "Sheet1". The font color is blue and underlined to signal the entries are hyperlinks. When user clicks on a selection, the link is opened in the web browser. Here are the macros that are used.
Workbook Open Event
Worksheet Sheet1 CodePlease Login or Register to view this content.
Module1 Code to Load the ComboBoxPlease Login or Register to view this content.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Excellent and perfect example,
thanks Leith
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks