I was originally trying to format UserForm text box values, so that when they populate the worksheet, they're in a hyperlink format, but according to what I'm reading, that can't be done. So, I decided to just try and implement code that updates the range in the worksheet, when the worksheet is activated.
I'm getting an error of "Invalid or Unqualified Reference" error and the ".Hyperlinks" is being highlighted.
I'm getting an error of "Invalid or Unqualified Reference" error and the ".Hyperlinks" is being highlighted.
Code:
Private Sub Worksheet_Activate()
Dim cEmail As Range
For Each cell In Range(cEmail)
.Hyperlinks.Add anchor:=cEmail, _
Address:="mailto:" & cEmail.Value, _
TextToDisplay:=cEmail
End Sub