VBA Excel Message Box

Resolved · High Priority · Version 2003

Fri 15 Aug 2008, 10:50 Delegate Michael said...

Michael has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Access VBA course

VBA Excel Message Box

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.

Tue 19 Aug 2008, 14:38 Trainer Stephen said...

RE: VBA Excel Message Box

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Difference between Two Dates

The DATEDIF function computes the difference between two dates. The DATEDIF function is as follows:

=DATEDIF (Date1,Date2,Interval)

Please note that Date1 must be less than (earlier) or equal to Date2

Please note that Interval must be one of the following codes: "d" (in days), "m" (in months), "y" (in years) expressed in quotes

View all Excel hints and tips