Running more than one macro with a button

J

João Correia

Hi, I have a droptable on my menu, and when an option is
selected it runs a macro with the VB
code 'button.OnAction = "Macro"'.
What I'm trying to do is to call more than one macro with
this button. If I put another code line in the next row
(something like button.OnAction = "Macro1") it only runs
the second (??) macro.
There's probably an easy way to put it all in the same
row or something like that.

Please, share with me your knowledge!!

Thanks
 
H

Helmut Weber

Hi João,
I am prefering simple solutions, though a complicated one
may sometimes be more entertaining. ;-)
Let "onaction" call a macro, that calls any number of macros.
Like, as this is the beginners' group:
Sub MainMacro
MakroA
MakroB
MakroC
...
end sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top