how to make this report?

[ariansman]

I have made a table which contains the data from some companies, such as company name, phone number and address, website, etc. I have also made a report over this table.
How can I make this report, so that if I click on the box that has the company website, it automatically open an explorer with that company website in the address bar?

 

[vbaInet]

Have a look at Application.FollowHyperlink

https://msdn.microsoft.com/en-us/library/office/ff822080.aspx

 

[ariansman]

thank you but i could not figure if i open the box properties and then, on click, then what i should write there. can anybody advise?

 

[GinaWhipp]

Hmm, try this...

Application.FollowHyperlink Me.NameOfYourTextBoxContainingWebsiteAddress