Simply double click on the button and it will take you to the control's
click event. From there you can call your macro.

Private Sub CommandButton1_Click()
Call MyMacro
End Sub


Private Sub MyMacro()
msgbox "Aw, you clicked me, how nice of you."
End Sub


"Jones E" <Jones wrote in message
...
I'm trying to use a Submit button to run a macro. Need Help.

Thanks
Eric