Run macro after cell entry

[Bidwin]

How can I create a condition to run a macro after a particular cell is modified? The best I've done so far is to run the macro after any cell on a sheet has been modified.
Thanks,
Bidwin

[lenze]

I think your're on the right track. Use the WorkSheet Change Event. Use an IF Statement, such as If Target.Address="$A$4" Then 'Your Macro'.

This will run only when the designated cell is changed

[James]

Heres 2 Examples:

SubTryThis()
Dim MyMacro As String
[A1] = "Hello"
MyMacro = [A1]
Run MyMacro
End Sub

Sub Hello()
MsgBox"Hello"
End Sub

Or..............

Private Sub Worksheet_Calculate()
If Me.Range("A1") = "" Then YourMacro
End Sub

Sub YourMacro()
MsgBox "A1 is empty!"
End Sub

Your macro could either be in the worksheet code module or in a standard module

James

[Bidwin]

lenze and James, Thanks for your replies. Both were very helpful. I got the macro to do what I intended it to do.
bidwin