MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Hyperlink is a Userform?


Posted by Paul Magruder on March 27, 2001 5:40 PM

Is there a way to put a Hyperlink in a Userform? I know I can use a button with a macro to open the desired workbook, but I was wondering if I can insert A Hyperlink......

Thanks in advance
Paul


Posted by Dave Hawley on March 27, 2001 6:00 PM


Paul, there is always a way with Excel!


Attach this code to a Label control.


Private Sub Label11_Click()
Application.ThisWorkbook.FollowHyperlink "http://www.ozgrid.com/"
End Sub


In the properties window of the Label select MouseIcon and have a Browse for a hand pointer.

Dave

OzGrid Business Applications