how to run macro in userform button

  • Thread starter khurram saddique
  • Start date
K

khurram saddique

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

tjtjjtjt

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
 
B

Bob Phillips

Private Sub CommandButton1_Click()
myMacro
End Sub

--

HTH

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