Checkboxes in userform VBA

Hello,

I have a userform that contains 16 checkboxes. The user will be able to tick as many of these checkboxes as they need, before clicking on the "OK" button (CommandButton5). Everything else is all set up and ready to go, all I need is the code to...

- When the user selects CommandButton5 (OK) it needs to run other macros depending on which checkboxes are ticked. For example, call 'macro1' if checkbox1 is ticked, call 'macro2' if checkbox2 is ticked... and so on (all the way up to checkbox16).
- Run macro20 if the user clicks on OK without having ticked any of the checkboxes.

Hope this makes sense!

Many thanks for your help!

Please Login or Register  to view this content.

With this method if the Checkbox's name is CheckBox1 it should run Macro1 and so on.