Hi All
I'm trying to solve this: got userform with listbox and one "depending" button when is click to open docs from folder. What I want is: depending on where I click on listbox, button hyperlink to change to different doc.
Is that possible!??
in other words
Code
Select Case Me.Listbox1
Case .Selected.Listbox1.ListIndex = 1
btnDocs = ActiveWorkbook.FollowHyperlink Address:="Mac:Users:dmb:Dropbox:Machine:folder1:image1.jpg", NewWindow:=True
Case .Selected.Listbox1.ListIndex = 2
btnDocs = ActiveWorkbook.FollowHyperlink Address:="Mac:Users:dmb:Dropbox:Machine:folder2:image1.jpg", NewWindow:=True
Case Else
End Select
Any help will be appreciated
cheers