Hi,
In a spreadsheet that I'm working on the user makes several selections.
One of the selections is accompanied by an 'Info' Button. When pressed a userform appears with various information related to that chosen option.
2 of those bits of information are a url and an email address.
I've been able to use a userform label as a link for the url no problem. I can't find a way to use the email address though. Does anyone know how I can do that?
Dependant on the selections the user makes the info shown on the userform varies so the email address must be derived from a cells contents. For the link to the url I'm using;
Which is working well. The corresponding email address is stored in "AC DATA" cell L4.
Rgds & many thanks in advance.
Richard
In a spreadsheet that I'm working on the user makes several selections.
One of the selections is accompanied by an 'Info' Button. When pressed a userform appears with various information related to that chosen option.
2 of those bits of information are a url and an email address.
I've been able to use a userform label as a link for the url no problem. I can't find a way to use the email address though. Does anyone know how I can do that?
Dependant on the selections the user makes the info shown on the userform varies so the email address must be derived from a cells contents. For the link to the url I'm using;
Code:
Private Sub Label17_Click()
ActiveWorkbook.FollowHyperlink Address:=Sheets("AC DATA").Range("G4").Value
End Sub
Which is working well. The corresponding email address is stored in "AC DATA" cell L4.
Rgds & many thanks in advance.
Richard