Hyperlink in msgbox 1

[leassaf]

Does anyone know a way of making a part of a text in a msgbox be a hyperlink (to a file or a URL)?

 

[xlbo]

AFAIK, this can't be done as a message box has to return a yes or no constant to excel - you might want to look at creating a userform that looks like a message box - then I think you can put hyperlinks on forms (failing that you can use a button)
HTH
Geoff

 

[ratman]

Ratman Special of the Day:

Sub hyperlinkInMsgBox()
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="

http://www.espn.com/"

msg = "Do you want to go to

http://www.espn.com

now?"
Ans = MsgBox(msg, vbQuestion + vbYesNoCancel)
Select Case Ans
Case vbYes
ActiveSheet.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
Application.WindowState = xlNormal
GoTo alldone
Case vbNo
Cancel = True
GoTo alldone
Case vbCancel
Cancel = True
GoTo alldone
End Select
alldone:
End Sub

 

[xlbo]

Very nice Ratman - have a star - that's a good workaround - would suggest a:
Selection.clearcontents after alldone: though - just to tidy up

Rgds
Geoff