View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default IS it possible to add Hyperlink to a commandbutton on a Userform

Option Explicit
Private Sub CommandButton1_Click()
ThisWorkbook.FollowHyperlink Address:="http://www.microsoft.com"
End Sub

I think I'd use a label--format with blue font and underline--like a hyperlink
you'd see in the worksheet.

Ayo wrote:

I have a userform with a commandbutton. I want to add an hyperlink to the
commandbutton so that when the commandbutton is click, it opens up the
website. How do I go about doing that?
Thanks


--

Dave Peterson