Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
Macro to Copy Hyperlink to another file as a HYPERLINK, not text... | Excel Programming | |||
reading html when hyperlink address not hyperlink text diplayed | Excel Programming |