John,

You can use the Worksheet_Change event procedure and test which cell was
changed. For example,

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$2" Then
MsgBox "Do something "
End If
End Sub

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"John Baker" wrote in message
...
Hi

I have a situation where I would like to activate a macro after a change
in the contents
of a single cell. I know that this can be done for applications and
worksheets, but can
someone tell me how to make it happen for a single cell. Note that I am
not very good at
VBA coding, so any details would be helpful.

Thanks

John Baker