Hi Add this into a new module:
Sub Auto_Open
MsgBox "Put your message here" , vbinformation + vbokonly , "Your Message"
End Sub
Can I create a message box that displays a message when the spreadsheet is first opened?
If so, where do I put it?
Hi Add this into a new module:
Sub Auto_Open
MsgBox "Put your message here" , vbinformation + vbokonly , "Your Message"
End Sub
You will need to put the following in the ThisWorkbook module:
Private Sub Workbook_Open()
MsgBox "Hello",vbOkOnly+vbExclamation,"Title for HELLO"
End Sub
Silly Billy was here....
***************** EXCEL/VB NEWBIES ARE MY FAVORITE! *****************
Worked like a charm! Thanks for the information from both of you.
BTW, like Kevin.Philips said, it doesn't have to go in the Thisworkbook module, I put it in an empty module that I had open and it worked great!
This is true, it will work, but the Auto_Open procedure is the older way of doing what you want. The Worksheet_Open event is the "cleaner" way to do this.
Glad I saw this thread. I have a spreadsheet that I have a pop up window with a message which works almost fine.....the message appears, but it stays minimised with the sheet on the taskbar, which isn't always obvious to users, have I created my message incorrectly?
Any thoughts greatly appreciated!
Like this thread? Share it with others