Hyperlinking Dropdown List Items

[Oz]

How can I activate hyperlinks associated with the items in a dropdown list so that for example if a click on an item I will goto a word document related to it?

 

[zacemmel]

You would have to do a combo box and add some VBA code to it to open the selected file in Word when the combobox changes:

Private Sub ComboBox1_Change()
'your code to open the word file here
End Sub

 

[Oz]

Thanks Zac I'll give it a try