Initiate a macro in a cell

[dvess11]

I know how to create a button and assign my macro to it. Click on the button and the macro runs. I'm wondering if I can initiate 1 of several macros based on values from other cells? For example let's say I click on my button, if C1 = 1 and D1 = 1, then macro A runs; if C1 = 5 and D1 = 2, macro B runs; if C1 = 11 and D1 = 1, macro C runs .... and so on.

[6StringJazzer]

When you say macro A, macro B, let's say you are talking about Subs. Your existing macro would look like this:

Please Login or Register  to view this content.

[Murtadau_Gabier]

Scrap my comment, Stringer has got this

regards,
Murtadau

[dvess11]

Thank you 6StringJazzer. I have a couple follow-up questions. Given that my existing macros are in separate modules:

1) Do I need to use the "Public" and "Private" prefixes?
2) Do I need to append my macro subs to your program as shown above or will your program call them from the separate modules?

[Arkadi]

Hi dvess,

Clearly 6StringJazzer has this under control, I was just browsing... but can quickly answer your questions. If a sub has "Private" as its prefix, it can't be called from another Module. If your macros are not in Private subs, then they can stay where they are, and will run just fine if you just put his code into any module (existing OR new).

[6StringJazzer]

To just add to Arkadi's explanation, the default is Public, and you can move things around and make anything Public if you have things in different modules. You don't have to do it exactly the way I showed. That is the answer to VBA coding semantics.

Whether things should be in the same or different modules is a design issue, but I don't know your big picture.

[dvess11]

Thanks guys. Everything is working well.