Solved: How to create Hyperlink

[JohnyG]

I am creating a user form wherein I have to show a "Menu" that contains several items under it. eg.

Menu

1. Brokers Details
2. Producer Details and so on.

I want to create these names (Broker Details) as hyperlink so that as and when user clicks on this it will open file that contains Broker detailes (which is actually a excel) similarly Producer file is in MS word format.

Please help

[dominicb]

Good afternoon JohnyG

You can't add a hyperlink to a userform, but using a little trickery you can make a clickable link look like a hyperlink. John Walkenbach explains all here (http://spreadsheetpage.com/index.php/tip/adding_a_hyperlink_to_a_userform/).

HTH

DominicB

[JohnyG]

Wao ... u guys are genious ..

Thanks u sir...


Regards