how do I create a macro that will activate other macros?

[sbrigham]

I am trying to create a Macro that will click on controls that have macros
assigned, this isn't working so I want to know if there is a way to nest the
sub's into this macro.

 

[John Bundy]

If you will put your macro's as functions or subs into a module (right click
your project and insert module) then you can call them from anywhere. example
Function CountStuff()
code
End Function
then under your click event,and anywhere else, just call CountStuff() and it
will run that code.

 

[Jim Thomlinson]

The standard way to do this is not to click on the other controls but rather
to run the code associated with those controls. So something like this...

sub LotsOfStuff()
Call DoThis
Call DoThat
end sub

sub DoThis()
msgbox "do this"
end sub

sub DoThat
msgbox "do that"
end sub

 

[sbrigham]

Thank you! I was missing the call part.

The standard way to do this is not to click on the other controls but rather
to run the code associated with those controls. So something like this...

sub LotsOfStuff()
Call DoThis
Call DoThat
end sub

sub DoThis()
msgbox "do this"
end sub

sub DoThat
msgbox "do that"
end sub