Multiple VBA with multiple check boxes and one Button

[Luka_LB]

Hi everyone

I'm havin' this issue

i have for e.g. 10 VBA and 10 check boxes and an 'execute' button

so, i want this button execute exactly that vba, which I will select by checking checkbox

Each time there will be only one box checked

also I'll need to have names for boxes like you can see attached picture

and could you please explain more detailed way, because i'm a beginner

thank you in advance for your time and help

 

[Luka_LB]

 

[Damon Ostrander]

Hi Luka_LB,

Firstly, you mention that only one checkbox will be checked. This being the case you should be using optionbuttons rather than checkboxes. Optionbuttons enforce that only one option can be selected. The following will work with either checkboxes or optionbuttons, but be aware that if multiple checkboxes are checked only the first (top) one will be run.

I recommend that you name each optionbutton (using the Name property of each optionbutton) to make the code clearer. In this code I named three optionbuttons WriteOB, ErazeOB, and DivideOB. Note that I also named the Execute commandbutton ExecuteCB. Also note that in this code the statement

If WriteOB Then

is equivalent to

If WriteOB.Value = True Then

where the Value property of the optionbutton yields True if the option is selected, False otherwise.

Put this code in the commandbutton's Click event like this.

Private Sub ExecuteCB_Click()
   If WriteOB Then
      MsgBox "Run Write macro"
   ElseIf ErazeOB Then
      MsgBox "Run Eraze macro"
   ElseIf DivideOB Then
      MsgBox "Run Divide macro"
   'add ElseIF statements for remaining optionbuttons here
   End If
   
   Unload Me 'this unloads the form when done
End Sub

Simply replace each MsgBox statement with the macro name that you want to run for that option.

Keep Excelling.

Damon

 

[Luka_LB]

Thank you Damon Ostrander for your time and for such good explaining and detailed post and for your advises!

Thanks a lot!!!