MsgBox
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 |
MsgBox
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 -----Original Message----- 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 . |
All times are GMT +1. The time now is 03:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com