Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Rtr interface
|
|
|
The UK's most regular 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. |
Rtr interface
Resolved · Low Priority · Version 2007
Reply Thu 5 Feb 2009, 17:03Delegate Sebastian said...
Sebastian has attended:
Excel VBA Intro Intermediate course
Rtr interface
How do I create an interface box/menu where i can select which macro's/events I would like to run?
For upcoming training course dates see: Pricing & availability
RE: rtr interface
Hi Sebastian
Thank you for your question
First create a combo box that populates with the names for the macros that you want to run. This should be run on the form's on open event.
Your user would then select the macro to run and click a command button which would run a main procedure. You would then use a select case statement for the value of the combo box, running the appropriate macro for the value selected in the combo box.
Hope this is useful
Regards
Stephen
Mon 20 Apr 2009: Automatically marked as resolved.
|