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

certain_death wrote:
>
> 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
>
> --
> certain_death
> ------------------------------------------------------------------------
> certain_death's Profile: http://www.excelforum.com/member.php...o&userid=24561
> View this thread: http://www.excelforum.com/showthread...hreadid=547494

--

Dave Peterson

[CLR]

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" wrote:

> 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 wrote:
> >
> > 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
> >
> > --
> > certain_death
> > ------------------------------------------------------------------------
> > certain_death's Profile: http://www.excelforum.com/member.php...o&userid=24561
> > View this thread: http://www.excelforum.com/showthread...hreadid=547494
>
> --
>
> Dave Peterson
>

[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 i 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 visual appearance and conditioning that can be applied try putting this in the code of the form and it shall work

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


End Sub



cheers

[certain_death]

That's great..that will be very helpful

Thanks to all concerned...
Take it easy
Mark