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" 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 |
All times are GMT +1. The time now is 04:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com