Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How I assign a micro to a command button?
And How i assign 5 micros to a one command button? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
hi,
right click the button. from the popup menu, select "view code". the default should be the click event. If you have already written the macro, then you can use the call command to call it from the button code. if not, then you can put your macro directly into the button code. if running 5 macros, i would write them seperate and use the call command private Sub Commandbutton1_Click() Call macro1 Call macro2 Call macro3 Call macro4 Call macro5 End Sub used this way, each macro will run in turn, one after the other so be sure to get your sequences in order. Regards FSt1 "Qazi Ahmad" wrote: How I assign a micro to a command button? And How i assign 5 micros to a one command button? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA Command Button | Excel Discussion (Misc queries) | |||
Command Button | Excel Worksheet Functions | |||
Assing a macro to a contro. | Excel Discussion (Misc queries) | |||
command button | Excel Discussion (Misc queries) | |||
Command Button | New Users to Excel |