Chip,

Thanks for your help on this. It was starting to drive me nuts.
Now I am playing around with this little treasure like a kid in a toy store.
:)

Do you know where I could find a list of these worksheet functions?

Thanks again!

Joe


"Chip Pearson" wrote in message
...
Joe,

The Target parameter passed to the SelectionChange and Change
events is a Range reference that refers to the cell(s). From your
description, I think you want to use the Change event rather than
the SelectionChange event. E.g.,

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
MsgBox "You entered: " & Target.Value
End If
End Sub


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


"Joe" wrote in message
...
How do I determine what cell information was entered into using
the
worksheet SelectionChange Sub? I am trying to use VBA to
validate and
change a number when info is entered into a cell in a certain
range. Any
help is greatly appreciated.

Joe