Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I create a URL with link using the VBA form.
I have created a form for user entry to add a record. The form consist
of a column which allows user to enter a URL of a web site. The value can be inserted to the cell successfully, however, the url is just displayed as a text with a link. So I want to ask how can I create the link automatically? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I create a URL with link using the VBA form.
One way is to add the string as part of an =hyperlink() formula:
Say they type www.ms.com (no http://). then this would work: Worksheets("sheet1").Range("a1").Formula _ = "=hyperlink(""http://" & myForm.TextBox1.Value & """)" Daniel wrote: I have created a form for user entry to add a record. The form consist of a column which allows user to enter a URL of a web site. The value can be inserted to the cell successfully, however, the url is just displayed as a text with a link. So I want to ask how can I create the link automatically? Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link To Form Tools | Links and Linking in Excel | |||
I am trying to create a form in Excel. In my form I want to be abl | Excel Discussion (Misc queries) | |||
How to create a form to insert a hyerlink.VBA code to create a for | Excel Discussion (Misc queries) | |||
How to create the URL with link using the VBA form input in excel? | Excel Programming | |||
VB form link | Excel Programming |