VBA Excel Message Box

The UK's most regular instructor-led training courses.
Training information: excel microsoft training · Excel course · VBA training UK

Resolved · High Priority · Version 2003

VBA Excel Message Box

Michael has attended:
Excel Advanced course
Excel VBA course

by - delegate Michael [7 posts] (2008 Aug 15 Fri, 10:50) Reply

Is it possible to rename the buttons in a message box and have a specific routine run depending on the button chosen (i.e. Rename default 'Yes' to 'Routine 1' and so forth for a total of three buttons). Would I be better placed using a series of radio buttons ? Context : Upon opening a workbook a pop up message box will ask the user which action they would like to perform.

Many Thanks.

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	3	book now	£525	£545
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	7	book now	£450	£475
2003	2009 Jan 22 Thu + 23 Fri	Southwark	4	book now	£475	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	5	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
2003	2009 Feb 19 Thu + 20 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 33 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: VBA Excel Message Box

by - trainer Stephen gold contributer [386 posts] (2008 Aug 19 Tue, 14:38) Reply

Hi Michael

Thanks for your question

I think it would be better if instead of using a message box, you create a popup form with command buttons captioned Routine one, Routine two etc.

You can the call your routines from the button's on click event

Alternatively, as you suggest you could select the routine by using an option group

Regards

Stephen