Pop up MsgBox upon opening Excel File

[certain_death]

Hi,
Can anyone help?
I would like a pop up message box upon opening a spreadsheet, that
would contain some of assumptions in the spreadsheet...
Please help if you can...
Nice one
Regards
Mark

 

[Dave Peterson]

Option Explicit
Sub Auto_Open()
msgbox "Your message here" & vblf & "second line if you have one"
end sub

This goes into a general module.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Guest]

This mod of Dave's code will also present the value in cell A1 in the Message
Box if you wish....

Option Explicit
Sub Auto_Open()
MsgBox "Your message here" & vbLf & Range("a1").Value
End Sub

Vaya con Dios,
Chuck, CABGx3

Option Explicit
Sub Auto_Open()
msgbox "Your message here" & vblf & "second line if you have one"
end sub

This goes into a general module.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[certain_death]

Hi guys
Thanks for your help
As a further help is there a way of changing the message box so the
user doesnt have to click ok....it just stays there for 5 seconds and
disappears?
Thanks
Mark

 

[Zygan]

never heard or seen a away to have a msgbox without a ok button
pictures and cancel buttons and what not but never without a button
however you could write
workbook_open
userform1.show
end sub

This will display a form called sub and the forms have way more visua
appearance and conditioning that can be applied try putting this in th
code of the form and it shall work

Private Sub UserForm_Activate()
Application.Wait Now + TimeValue("00:00:10")
unload Me


End Sub



cheer

 

[certain_death]

That's great..that will be very helpful

Thanks to all concerned...
Take it easy
Mark