submit button in macro

[Jones E]

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

Thanks
Eric

[AMDRIT]

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 [email protected]> wrote in message
news:[email protected]...
> I'm trying to use a Submit button to run a macro. Need Help.
>
> Thanks
> Eric

[Jones E]

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 [email protected]> wrote in message
> news:[email protected]...
> > I'm trying to use a Submit button to run a macro. Need Help.
> >
> > Thanks
> > Eric
>
>
>