MsgBox

[redmad]

I would like the MsgBox to appear before closing Excel file.
I have this code:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
MsgBox Prompt:="CONTENT", Title:="title"
End Sub

but I want a link to www site and to e-mail address in CONTENT
Could somebody tell me how to do this?

thanks

 

[Seth]

You cannot add hyperlinks to a VB message box (unless you
just want to show the text). All the MsgBox function can
do is show you text...I am unaware of any special text
formatting that can be applied - but if there is, I would
love to see it too .

You have to create a userform and put your link there.

Seth