Hyperlink

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
 
K

Keith74

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AppleScript - How do I select a text ? 1
Transfer data between two tables 3
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Optionbutton Not working 3
Generated text copies into another template 0
Eliminare un fastidioso avviso di sicurezza 0
Textbox's return a number? 2
How to Import Formatted text as new Slides in PowerPoint 0

Top