Can a Macro be run as part of an IF() statement
Can I run a macro as part of an IF statement i.e. IF(A2=1,Run Macro 1,Do
nothing ) I simplified what I want to happen but I want to automatically run a macro when a condition goes true in another cell. |
Can a Macro be run as part of an IF() statement
You cannot do it in a formula but event code could run the macro when A1=1
Private Sub Worksheet_Calculate() On Error GoTo stoppit Application.EnableEvents = False With Me.Range("A1") If .Value = 1 Then 'MsgBox "Please be advised that A1 is equal to 1" Macroname End If End With stoppit: Application.EnableEvents = True End Sub Gord Dibben MS Excel MVP On Thu, 4 Oct 2007 20:15:01 -0700, WAJ wrote: Can I run a macro as part of an IF statement i.e. IF(A2=1,Run Macro 1,Do nothing ) I simplified what I want to happen but I want to automatically run a macro when a condition goes true in another cell. |
All times are GMT +1. The time now is 10:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com