View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default How to assing micro to a command button

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?