Running a macro automatically when a cell with an IF formula changes.

[rbs123]

Hi,

New to VBA. Have a worksheet where cell A2 is has an IF formula which gives value as either 0 or 1, depending on the value in cell B2 which is a data validation cell. I want my macro to run everytime the value in cell A2 changes. Can someone please post a code to help me out? Thanks!

[AlphaFrog]

You can automatically run a macro when the user (not a formula) changes a cell value. Since the user is changing cell B2, try something like this.

• Right-click on the worksheet tab with the A2:B2 cells
• Select View Code from the pop-up context menu
• Paste the code below in the worksheet's code module
• Change the name of MyMacro to the name of your macro

Please Login or Register  to view this content.

Your macro can then test the value of the IF formula in A2.

[rbs123]

Thanks