Run macro in IF function

[Dan23cd]

=IF($A$11=1,"macro1","Macro2")

What is the code for the above if I want a respective macro -- in my example, macro 1 to run if A11 has a 1 and macro 2 to run if different value?

Thanks.

[AB33]

Please Login or Register  to view this content.

[barryleajo]

OOPs and with acknowledgements to AB33 - just in case the shorthand/psuedo code confuses,
perhaps variations on the following

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[Dan23cd]

Thanks --so can run a macro within an IF type function -- my actual situation is a somewhat more complicated -- have 6 choices for cell A11 -- 1a,1b,2a,2b,3a,3b. Depending on the contents of A11 a different macro is run. Can I do this and if so How?

Thanks again.

[barryleajo]

Perhaps a variation on this to suit your requirements?

Please Login or Register  to view this content.

[MrShorty]

=IF($A$11=1,"macro1","Macro2")

The only way this really works is if "macro1" and "macro2" are written as user-defined functions (A VBA function procedure that is written so it can be called directly from an Excel cell like Excel's built in functions). UDF's can perform calculations and return values to the cell(s) they are called from, but they cannot perform actions like deleting, formatting, copying, etc. You haven't specified what "macro1" and "macro2" do. If they are computing a value so that they can be set up as UDFs, then you should be able to use them like you are suggesting. If they are doing other things, then you will need code like the other responses have suggested - your VBA procedure will have to test the condition and call macro1 and macro2 accordingly.

[feliciawong]

Hi,

I have read the reply and just wondered if the same expert can help me with similar enquiry:

If I want to copy cell A to a new line of a new worksheet when "option a" is selected/entered for cell B of the same record?

Await your advice,
thanks

[shg]

Felicia, please start your own thread.