Pop up MsgBox upon opening Excel File

  • Thread starter Thread starter certain_death
  • Start date Start date
C

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
 
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




Dave Peterson said:
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
Click to expand...
 
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:) :)
 
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
 
That's great..that will be very helpful

Thanks to all concerned...
Take it easy
Mark
:) :)
 
Back
Top