Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Private Sub CommandButton1_Click()
myMacro End Sub -- HTH RP (remove nothere from the email address if mailing direct) "khurram saddique" wrote in message ... i have made a button (cmd1) on form (frm1) i want to run a macro by clicking the button what should i do regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I run a macro in the background whilst a UserForm is visib | Excel Discussion (Misc queries) | |||
Assigning a macro to a "button" | Excel Discussion (Misc queries) | |||
How to assign a macro to a commnd button | Excel Discussion (Misc queries) | |||
assign a macro to a control button | Excel Discussion (Misc queries) | |||
Macro button colour change??? | Excel Worksheet Functions |