How to assing micro to a command button

G

Guest

How I assign a micro to a command button?
And How i assign 5 micros to a one command button?
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to assign macro coding into customized button? 4
Assign Function to a Command Button 1
Command Button 7
Command Button Excel 2007 4
Command button macro 6
how do you assign a macro to a command button in Excel 2003 5
Command Button for Macro on a Toolbar 7
How to use multiple command button to copy user form data to multiple worksheet 0

Top