Call Multiple Macros From One

alexanderbingha · Dec 1st 2006

I have a number of VBA functions that I want to be executed when either the cell is filled in or upon the click of a inserted button. I see how to attach a single macro/VBA function to a button but I can not attach more than one function.

Wigi · Dec 1st 2006

Re: Calling Multiple Macros

Hi Alexander

welcome to Ozgrid : D

Do you want to execute a macro when a condition is true and another when it is false? I didn't fully understand your question.

Wigi

tinyjack · Dec 1st 2006

Re: Calling Multiple Macros

Just wrap them in a sub, so

Code

Sub RunAll()
   Sub1
   Sub2
End Sub

then attach that to the button.

TJ

alexanderbingha · Dec 1st 2006

Re: Calling Multiple Macros

Thanks tinyjack! That was what I needed.

Wigi · Dec 1st 2006

Re: Calling Multiple Macros

That's indeed how you should proceed. I first thought you wanted to execute to things at the same time (which is not possible). Anyway, glad it's solved.

Have a nice weekend

Wigi

Dave Hawley · Dec 2nd 2006

Re: Calling Multiple Macros

You should use the Run or Call Statement. If the Procedures be called are not in the same Module just using the name will fail.

Call Multiple Macros From One

Participate now!

Share