Running macros with macros

[scanavan]

I am looking to for the VB script that will allow me to operate a second macro within the current macro that is being executed.

Can anyone help?

 

[VoG]

Like this?

Sub macro1()
'code
Call Macro2
'more code
End Sub


Sub Macro2()
'code
End Sub

 

[Lewiy]

You can call the second macro by simply using it’s name:

Sub Macro1()
MsgBox "This is Macro1"
Macro2
End Sub

Sub Macro2()
MsgBox "This is Macro2"
End Sub

 

[al_b_cnu]

Hi,

Why not just call the other macro , e.g.

Sub Macro1()

Call Macro2 (1,2 3)

End Sub

Sub Macro2(byVal A as Integer,byVal B as Integer, ByVal C as Integer)
.....
End Sub

 

[scanavan]

Thank you everyone.

Exactly what I was looking for.