Hyperlinks and drop down lists

  • Thread starter Thread starter jhodge
  • Start date Start date
J

jhodge

I would like to know if it is possible to have hyperlinks in a drop dow
list. Currently I have all the different jobs hyperlinked to th
corresponding page but I would like to put them in a drop down list
can such a thing be done
 
Hi
AFAIK you can't have hyperlinks directly in a listbox though you may
consider one of the following workarounds:
1. Use a listbox with the text values and use a helper column for
referencing using the HYPERLINK function

2. You may also try to use VBA. In this case for example the
worksheet_change / or selection_change event to change the choosen
listbox entry to a hyperlink via code
 
Back
Top