submit button in macro
 

I'm trying to use a Submit button to run a macro. Need Help.

Thanks
Eric

submit button in macro
 

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

submit button in macro
 

Thanks so much, worked Great

"AMDRIT" wrote:

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