when you're in design mode, making changes to the userform, double-
click on the checkbox you want to call the macro. this will open the
VB editor & you will see something like:
Private Sub Checkbox1_Click()
*****
End Sub
except there won't be any stars there. where the stars are, that's
where you code goes. if your code is in a module in the project or in
the userform module you simply write:
Call MyCode '<--- change to the name of your code
and it will make that code run.
:)
susan
On Sep 24, 3:18*pm, Mr Imnotabrainsurgeon <Mr
wrote:
I have created my first macro (don't laugh) and I want the macro to start
when I check off a check box in the form I made.
How do I do this?