countryfan_nt
Well-known Member
- Joined
- May 19, 2004
- Messages
- 758
Hello Friends, Hope all is well! Please help me with the below code.
It is a userform, I want the email addresses below to be hyperlinks (clickable). I am referring to: "TieFighter@empire.com and Xwing@Rebels.com.
Thank you so much!
It is a userform, I want the email addresses below to be hyperlinks (clickable). I am referring to: "TieFighter@empire.com and Xwing@Rebels.com.
Thank you so much!
VBA Code:
Private Sub Label1_Click()
Label1.Caption = "Greetings " & Application.UserName & "," & vbNewLine & _
"Dr. Pepper Proudly presents:" & vbNewLine & _
"The 2021 database" & vbNewLine & _
"For any assistance please do not hesitate to contact us at any time:" & vbNewLine & _
"TieFighter@empire.com" & vbNewLine & _
"or" & vbNewLine & _
"Xwing@Rebels.com" & vbNewLine & _
"" & vbNewLine
End Sub