ExcelBanter - Hyperlink

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Hyperlink (https://www.excelbanter.com/excel-programming/408634-hyperlink.html)

Adam[_18_]

Hyperlink

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

Keith74

Hyperlink

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

All times are GMT +1. The time now is 04:59 AM.