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

Textbox's return a number? 2
make a data entry into hyperlink using vba? 3
Arbitrary data to Textboxes in UserForm 4
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
print labels from userform 4
Transfer Data from UserForm to Worksheet 8
Multipage Control in a Userform 1

Top