Hello,

I have several macro that need to be ran once a button is click.
What VB code I put to tell it to run several macro?

You run the first macro then call the second from that i.e.

Sub Sonic()
'do something
mynextmacro
end sub


Sub mynextmacro()
'do something else
mythirdmacro
end sub

sub mythirdmacro()
etc

Mike


"Cam" wrote:

Hello,

I have several macro that need to be ran once a button is click.
What VB code I put to tell it to run several macro?

To be more specific:

'Coce behind the command button

Private Sub CommandButton1_Click()
MainMacro
End Sub

'Code in standard code Module1

Sub MainMacro
Macro1name
Macro2name
Macro3name
...
Macronname
End Sub

"Cam" wrote:

Hello,

I have several macro that need to be ran once a button is click.
What VB code I put to tell it to run several macro?

Typo!
Shoud be Sub MainMacro()

"JLGWhiz" wrote:

To be more specific:

'Coce behind the command button

Private Sub CommandButton1_Click()
MainMacro
End Sub

'Code in standard code Module1

Sub MainMacro
Macro1name
Macro2name
Macro3name
...
Macronname
End Sub

"Cam" wrote:

Hello,

I have several macro that need to be ran once a button is click.
What VB code I put to tell it to run several macro?