The direct answer is to set up a bunch of If Statements. Something like this:
This is by no means the best way, but given the limited information, it is a solution.![]()
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
Bookmarks