I've been away a couple of days.

I am surprised you have not received an answer.

Try this in the sheet module.

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


Gord

On Wed, 19 Dec 2007 22:44:01 -0800, SLE wrote:

B2 is changed by calculation.
Let us say B2 is "=B1".
If I Manualy change the value in B1, then the value in B2 is changed also.
This value change in B2 must create the event that runs the macro.

"Gord Dibben" wrote:

How does B2 get changed?

Manually or by calculation?

Event code can be used but type of event is crucial for an answer.


Gord Dibben MS Excel MVP

On Tue, 18 Dec 2007 22:43:01 -0800, SLE wrote:

I have a macro and I can off cause run it from "Alt + F8". But how can I run
the mecro each time the cell B2 is changing value?