98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA Excel Message Box
VBA Excel Message Box
Resolved · High Priority · Version 2003
Fri 15 Aug 2008, 10:50Delegate 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:38Trainer 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 information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Difference between Two DatesThe DATEDIF function computes the difference between two dates. The DATEDIF function is as follows: |
