If statement result runs a MACRO

[danmazz]

I have various MACROS in this worksheet and need to run specific MACROS based on the result of an 'IF' statement result. Can this be done? Basically, if YES then do this, If NO then do that.

Thank you

[bodhi808]

You can add a macro to the worksheet itself and use it to check if a particular cell matches what you want to run your macros.

ie if you are wishing to check cell a1

Private Sub Worksheet_Change(ByVal Target As Range)
if range("A1").value = x then
    {macro_1}
end if
End Sub