Run Macro From If Statement

[bhalooneel]

Is there a command to run a macro as the condition for TRUE in an IF statement?

[tkaplan]

if x=y then
<<macroname>>
end if

[jose luis]

Could you tell where is the IF statment located? in a Cell or in a Macro? it depends...

Is there a command to run a macro as the condition for TRUE in an IF statement?

[bhalooneel]

It's in the cell.

[jose luis]

It's in the cell.

1. Put your IF in the cell
2. Label the cell (lets say SwCell)
3. put your macro in the Worksheet.Calculate. Something like

Please Login or Register  to view this content.

4. Pull the result of the Cell to your Macro with Range("Condition onSwCell")


Your Macro will run every time the worksheet is calculated, if it in automatic calculation, always will be testting your condition and doing your code.


Hope this helps

Regards

Jose Luis