I am trying to execute a macro with an “if statement” or cell value. So, for example, if the value of cell ((B4 > 10, “trigger macro”, "value is less than 10.))
Any advice or tips most welcome.
I am trying to execute a macro with an “if statement” or cell value. So, for example, if the value of cell ((B4 > 10, “trigger macro”, "value is less than 10.))
Any advice or tips most welcome.
Hi, @MoritZ1 what about this topic? Event driven macro triggered "on cell change" WITHOUT a listener You can just create an event, that runs your macro, when contents are changed. Just put conditional test in your macro code against B4 value and voila!