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 business analysis, project management, and also 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 in Access / Excel
- Microsoft Specialist in MS Project
- Microsoft Technical Associate
- Microsoft Certified Professional
- IBM SPSS Specialist

Leave a Reply

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