ExcelBanter - run macro in formula with "if" condition

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - run macro in formula with "if" condition (https://www.excelbanter.com/excel-programming/434056-run-macro-formula-if-condition.html)

run macro in formula with "if" condition

Gord Dibben

run macro in formula with "if" condition

Only by using worksheet event code like

Private Sub Worksheet_Calculate()
On Error GoTo stoppit
Application.EnableEvents = False
With Me.Range("A1")
If .Value = 123 Then
Call macroname
End If
End With
stoppit:
Application.EnableEvents = True
End Sub

Gord Dibben MS Excel MVP

On Wed, 23 Sep 2009 22:20:03 -0700, wg wrote:

All times are GMT +1. The time now is 10:00 AM.