Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Commandbutton in UserForm to run Macro
i have created 2 commandbutton in UserForm. i also created 2 macros bu
i dont know how to link the commandbuttons in userform to macro. seeking for help!!! thanx :rolleyes -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Commandbutton in UserForm to run Macro
in the VBE with the userform visible, double click on the first command
button. You should see Private Sub CommandButton1_Click() End Sub (it will have the name you assigned you commandbutton) Put a call to your macro there Private Sub CommandButton1_Click() mymacro1 End Sub In the left dropdown at the top of the module, select the other commandbutton. In the left dropdown, select click. You should get a similar declaration and you can call your second macro from there. -- Regards, Tom Ogilvy "salihyil " wrote in message ... i have created 2 commandbutton in UserForm. i also created 2 macros but i dont know how to link the commandbuttons in userform to macro. seeking for help!!! thanx --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Commandbutton in UserForm to run Macro
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I use a UserForm Box with a Macro? | Excel Discussion (Misc queries) | |||
how do i make a commandbutton run a macro?? | New Users to Excel | |||
CommandButton - Userform | Excel Discussion (Misc queries) | |||
Macro won't run from CommandButton | Excel Programming | |||
Code runs different in a commandbutton than a macro why? | Excel Programming |