View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Linking a Document in a Messagebox

One mo

Option Explicit
Sub testme()
Dim resp As Long
resp = MsgBox(Prompt:="whateveryouwant", Buttons:=vbOKCancel)

If resp = vbOK Then
ThisWorkbook.FollowHyperlink "http:\\www.help.com"
End If
End Sub


wrote:

Hi,

I would like to write a link to a document in a message box.

Instead of writing

MsgBox "For more detailed help go to http://www.help.com/"

I would like to have a link in the message box that points to "http://
www.help.com/"

Is this possible and how does it work?


--

Dave Peterson