how to run macro in userform button

i have made a button (cmd1) on form (frm1)
i want to run a macro by clicking the button what should i do
regards

Open up the VBE and Double-Click on the button in question. This will take
you to the button's module with the Button_Click() event already selected.
Type or paste the code into this sub procedure.

I assume you know where the to go to access the VBE, but here are quick
direction just in case. Press Alt+F11 on your keyboard.

tj

"khurram saddique" wrote:

> i have made a button (cmd1) on form (frm1)
> i want to run a macro by clicking the button what should i do
> regards

Private Sub CommandButton1_Click()
myMacro
End Sub

--

HTH

RP
(remove nothere from the email address if mailing direct)


"khurram saddique" <[email protected]> wrote in
message news:[email protected]...
> i have made a button (cmd1) on form (frm1)
> i want to run a macro by clicking the button what should i do
> regards