Run Macro(s) based on checkbox selection(s)

Hello!

Quick question for a problem that should (at least I hope so) not be tricky for the real gurus here (tried searching but came up with a bit different solutions to which I am seeking).

I have a spreadsheet that has some 8 macros. I usually run those 8 macros separately. What I would like to do is create 8 checkboxes for each macro and then be able to run all the selected macros (1 to 8 at the same time).

For Example if I have Macro1, Macro3 and Macro7 checked in the checkbox, the new Macro would run those 3 macros. You get the idea. Any tips on how to create this Macro? Recording doesn't even record checkbox checkings..

Also, should I use activex or form checkboxes?


Sorry if this is a starter question, but I have only recently started doing things with VBA.

Many thanks in advance!

Originally Posted by AndyLitch

Active X is better.. code would be something like :-

Please Login or Register  to view this content.

Thanks Andy.

I get the Run-time error '424':

Object Required from the First line of the actual macro.