Debra Dalgleish has good instructions........with pictures.......at her site.

http://www.contextures.on.ca/xlUserForm01.html


Gord Dibben MS Excel MVP

On Fri, 27 Apr 2007 13:06:00 -0700, mgj72394
wrote:

I want to be able to have a user form with 4 checkboxes and a submit button.
The user can choose 1 or any combination of the checkboxes. Each of the
checkboxes corresponds to a different macro. When the submit button is
clicked, only the macros that the user has chosen will execute. How do I
accomplish this? I've got the user form built; I'm just not quite sure how to
code this to get the desired result. This form will be used in Excel 2003.
Thanks.