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