It is event code

Right click on the worksheet tab where you want this behavior. Select View
code.

Paste in the code.

--
Regards,
Tom Ogilvy

"John Baker" wrote in message
...
Chip:

Thanks. I Tried this (using the appropriate cell designation), and it
didn't work when set
up as a macro. It also didn't work when set up as a VBA item. Is the
problem that i need
to execute it in the startup (to make it active), or is it that it doesn't
point to the
actual sheet (name "input) where the cell at interest resides?

Thanks a lot for your help on this.

regards

John Baker
"Chip Pearson" wrote:

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