How can I create a URL with link using the VBA form.

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

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
 
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 & """)"
 
You must log in or register to reply here.

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

Create Fillable PDF Forms With LibreOffice Writer 3
Access Automatically Send a notification email once a record is added 0
Pop-up form that creates record that links 1:1 to main form 0
VBA code for pasting links -- modifying RDB code for summary workbook 10
Slidebar (scrollbar) insertion through VBA 3
How to write a VBA program to load the webpages automatically 1
VBA Forms 3
Displaying data in a VBA User Form 1

Back
Top