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 Human Resources professional based in Hong Kong, specialized in business analysis, project management, data transformation with Access and Excel.

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 *