Hyperlink

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

Hi

I have the follow code that puts the infomation given into a cell as
text from a userform.

ActiveCell.Offset(0, 3).Value = UserForm26.TextBox4.Value

How can i put the text into the cell as a Hyperlink?

Thanks in advance
 
Something very loosely along these line (untested)

ActiveSheet.Hyperlinks.Add Anchor:=
activesheet.range(ActiveCell.Offset(0, 3).address), Address:= _
"yoururlhere", TextToDisplay:= UserForm26.TextBox4.Value

HTH

Keith
 
Back
Top