run macro in formula with "if" condition

G

Gord Dibben

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 <[email protected]> wrote:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically hide rows with 0 value....faster? 5
Screen Flickers and slows down worksheet functions 5
cell change 8
Target.Offset(0, 36).Value Help 3
please help.is it possible re-edit macro to convert text like1530-2200 to time format automatically? 1
If one column is full, goto the next column 6
Fill Color Macro 5
Countdown Timer Followup 0

Top