Run different macros based on userform checkbox values

Hi all

Have been looking around to see if I could find the solution to my problem myself, but I have come up short..

Basically I am creating a userform containing 6 different checkboxes, 2 optionbuttons & 1 commandbutton.
I have 12 different macros (2 sets each with 6 macros), which must run depending on the selections made.

In short:
Any combo of the 6 checkboxes is possible

The option button decides whether to run a combo of the 6 macros in set 1 (based on user selection in the 6 checkboxes), or a combo of the 6 macros in set 2 (Still based on the user selection in the 6 checkboxes)

The command button executes the choices made..

If for example the user chooses checkbox 2, 4 & 6

If option button 1 is chosen - Then when U click RUN, macro no# 2, 4 & 6 must be run/called..
If option button 2 is chosen - Then when U click RUN, macro no# 8, 10 & 12 must be run/called..

Example picture of userform attached..

If anyone has a solution to the above please let me know.

Regards
Henrik

The direct answer is to set up a bunch of If Statements. Something like this:

Please Login or Register  to view this content.

This is by no means the best way, but given the limited information, it is a solution.

Hi again

Solved the issue I had..
The problem was quite small but yet for me very easy to miss..
I use an english version of Excel at work, and a danish version at home..

In english it's spelled "MACRO" but in danish it's spelled "MAKRO"

So with minor adjustments, using checkboxes and not comboboxes, below code works perfect for me..

Please Login or Register  to view this content.