message boxes

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Message boxes

The UK's most regular instructor-led training courses.
Training information: excel in courses · Excel advanced · Microsoft Office VBA training

Resolved · Low Priority · Version 2003

Message boxes

Matt has attended:
Excel VBA course
Excel VBA course

by - delegate Matt [1 post] (2008 May 2 Fri, 16:42) Reply

How can a message box automatically appear on opening a workbook?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Jul 17 Thu + 18 Fri	Bloomsbury	3	book now	£475	£495
2003/XP	2008 Jul 30 Wed + 31 Thu	Bayswater	5	book now	£450	£485
2003/XP	2008 Aug 7 Thu + 8 Fri	Bloomsbury	6	book now	£450	£485
2003/XP	2008 Aug 14 Thu + 15 Fri	Bloomsbury	5	book now	£450	£485
2003/XP	2008 Aug 26 Tue + 27 Wed	Bayswater	6	book now	£450	£485
2003/XP	2008 Sep 8 Mon + 9 Tue	Bayswater	7	book now	£345	£399
Full Schedule: See all 48 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Message boxes

by - trainer Roy [16 posts] (2008 May 12 Mon, 12:38) Reply

Matt,

Write a handler for the Workbook Open event, in the ThisWorkbook module - i.e.

Private Sub Workbook_Open()
MsgBox ("Hi there!")
End Sub

/Roy

Please browse our web site to find out more about
excel in courses and other Microsoft training courses.

Select your range of cells. Type the value, label or formula that you want to appear in all the selected cells and then press Ctrl+Enter.

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application

Main information pages