Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
rtr interface

ResolvedVersion 2007

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?

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.

Excel tip:

Concatenating Results of Formulas

To concatenate the results of formulas simply add the "&" after the formula or function closing bracket.

function1(....)&function2(.....)

see example Creating a range of monthly payments as text.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.