View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Combo Box Dropdown Menu

If they are not Excel file, you could use:
ThisWorkbook.FollowHyperlink combo1.text

NickHK

"RSHF" wrote in message
...
I have a combo box on a master sheet that lists an alphabetical menu of

files
for users to open. How do I attach hyperlinks to these files in the

dropdown
menu, so that users may scroll through the menu pick the file they want

and
then press a command button to open up the chosen file from the master

sheet.
The drop down menu also functions as a link to a seperate database so I

may
have to combine the code. Any suggestions?