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