RJSIGKITS
Board Regular
- Joined
- Apr 15, 2013
- Messages
- 109
Becoming a regular on here lately!
Okay, so I have cell D15 that a user selects a web address from a dropdown list, and clicks the Command button to be taken to that website.
I need the selection to go back to default after the the button is clicked and the user is taken to the website.
D15 has "Select..." displayed as default, and I need it to go back to displaying this once the button is clicked.
I've tried adding 'Then' and what-not, but not getting anywhere...
? somewhere, somehow?
Okay, so I have cell D15 that a user selects a web address from a dropdown list, and clicks the Command button to be taken to that website.
I need the selection to go back to default after the the button is clicked and the user is taken to the website.
D15 has "Select..." displayed as default, and I need it to go back to displaying this once the button is clicked.
Code:
Private Sub CommandButton4_Click()ActiveWorkbook.FollowHyperlink Address:="http://" & Range("D15").Value, NewWindow:=True
End Sub
I've tried adding 'Then' and what-not, but not getting anywhere...
Code:
Range("D15").Value, "Select..."