View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 292
Default one button for many (macro)

Hi

You can call several macros from one, that is pretty essential in
programming:

Sub Macrocollection()
Call Macro1
Call Macro2
Call Macro3
End Sub

Sub Macro1()
MsgBox "1"
End Sub

Sub Macro2()
MsgBox "2"
End Sub

Sub Macro3()
MsgBox "3"
End Sub

HTH. Best wishes Harald

"uriel78" skrev i melding
...
I've got a sheet in a workbook where I put 6 buttons; each one is assigned
to a macro and for my purpouse (and to control that code I write do the
right thins) I press them sequentially from 1 to 6 . Now, how can I define
another

TIA button that "press" buotton from 1 to 6 sequentially...?