Hyperlink -Syntax

[Benjamin]

'm new to VBA here.
What's the syntax for:
Go to this hypelink:

I want have a command button or text in a form hyperlink to a document on
our shared server.

I know the html syntax... can someone help me this.

Thanks in advance,

 

[jamescox]

Check the Excel VB IDE help on the Hyperlink.Follow method.

 

[Chip Pearson]

You can use

ThisWorkbook.FollowHyperlink "your_URL_here.htm"

This will work with any protocol link (e.g., http, ftp, mailto, etc)

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)