I would like to initiate a macro when a cell has a specific value or
satisfies a formula (e.g. AB). Is that possible? Thanks in advance. JS

Hi,

You could use the worksheet change event. Right click your sheet tab, view
code and paste this in

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Or IsEmpty(Target) Then Exit Sub
If Target.Address = "$A$1" Then
If IsNumeric(Target) Then
On Error Resume Next
Application.EnableEvents = False
If Target.Value Range("B1").Value Then
'do your thing
End If
Application.EnableEvents = True
On Error GoTo 0
End If
End If
End Sub

Now if A1 changes to a value greater than B1 you can run some code.

Mike


"Setts" wrote:

I would like to initiate a macro when a cell has a specific value or
satisfies a formula (e.g. AB). Is that possible? Thanks in advance. JS

More detail. Any cell, specific cell, before/after

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Setts" wrote in message
...
I would like to initiate a macro when a cell has a specific value or
satisfies a formula (e.g. AB). Is that possible? Thanks in advance. JS