View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mgj72394 mgj72394 is offline
external usenet poster
 
Posts: 3
Default How do I create an user form to run macros in excel?

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.