help with ms excel macro?

Question

is it possible in ms excel that particular macro will run only if some codition is satisfied, i mean say for example if A1=B1, then only the macro should run otherwise the macro should not run, or say if A1=10, then only macro should run. ? is it possible?

jgoulden answered to use if, but i m not getting where should i type. i am using buttons for macro

Answer 1

jgouldens if statement should work.
you are just missing the name of your macro

-click Tools
-click Macro
-Click Macros

this will give you a list of macros. just put the macro name in where jgoulden wrote macro1.
since you dont need 2 macros, you can just replace it with a zero.

Answer 2

You do not say what you want the macro to do, so I am wondering if a simple conditional formatting or an IF function will do instead of using a macro.

Answer 3

Sure, just use an IF statement:

IF ( A1 = B1 , MACRO_1, MACRO_2 )

MACRO_1 runs if the condition is satisfied; MACRO_2 is invoked if it is not.