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

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

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

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


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

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


--
Zygan
------------------------------------------------------------------------
Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423
View this thread: http://www.excelforum.com/showthread...hreadid=547494

That's great..that will be very helpful

Thanks to all concerned...
Take it easy
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