Excel VBA run hyperlink

Q&A_ExcelChart_Q006

Solution to trigger hyperlink

Use FollowHyperlink function to go to a website.

Public Sub hyper()
 ThisWorkbook.FollowHyperlink Range("C6").Value
 End Sub

For details of the FollowHyperlink, check out the below article
Excel VBA function FollowHyperlink

 

 

Wyman W
Wyman is a Business Analyst based in Hong Kong, specialized in creating custom Function and Sub solutions, and is proficient in report automation with Access.

He is also a:
- Microsoft Most Valuable Professional (Excel)
- Microsoft Community Contributor
- Microsoft Office Specialist
- Microsoft Specialist
- Microsoft Technical Associate
- Microsoft Certified Professional
- IBM SPSS Specialist

Leave a Reply

Your email address will not be published. Required fields are marked *