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:

Private Sub CommandButton1_Click()

If OptionButton1.Value = True Then
    If ComboBox1.Value = True Then Call Macro1
    If ComboBox2.Value = True Then Call Macro2
    'etc
    'etc
Else
    If ComboBox1.Value = True Then Call Macro8
    'etc
    'etc
End If

End Sub

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..

Sub OnExecute()

If UserForm1.OptionButton1.Value = True Then
    
    If UserForm1.CheckBox1.Value = True Then
        Call Makro1
    End If
    If UserForm1.CheckBox2.Value = True Then
        Call Makro2
    End If
    If UserForm1.CheckBox3.Value = True Then
        Call Makro3
    End If
    If UserForm1.CheckBox4.Value = True Then
        Call Makro4
    End If
    If UserForm1.CheckBox5.Value = True Then
        Call Makro5
    End If
    If UserForm1.CheckBox6.Value = True Then
        Call Makro6
    End If
    'etc
    'etc
Else
    
    If UserForm1.CheckBox1.Value = True Then
        Call Makro7
    End If
    If UserForm1.CheckBox2.Value = True Then
        Call Makro8
    End If
    If UserForm1.CheckBox3.Value = True Then
        Call Makro9
    End If
    If UserForm1.CheckBox4.Value = True Then
        Call Makro10
    End If
    If UserForm1.CheckBox5.Value = True Then
        Call Makro11
    End If
    If UserForm1.CheckBox6.Value = True Then
        Call Makro12
    End If
    'etc
    'etc
End If

End Sub