Input number in cell and automatically goes to cell where that num
 

I want to know how one can enter a four digit number in one worksheet in the
workbook and then automatically go to that cell where that number inputted is
(in the same workbook).

any help is appreciated!

thanks

Input number in cell and automatically goes to cell where that num
 

Put this is Sheet2 worksheet code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A1")) Is Nothing Then
Exit Sub
Else
v = Range("A1").Value
Sheets("Sheet3").Activate
For Each r In ActiveSheet.UsedRange
If r.Value = v Then
r.Select
Exit Sub
End If
Next
End If
End Sub

Put your numbers in Sheet3. If you enter a value in cell A1 in Sheet2, you
will automatically be taken to the cell in Sheet3 that matches the value.
--
Gary's Student


"overmyhead" wrote:

I want to know how one can enter a four digit number in one worksheet in the
workbook and then automatically go to that cell where that number inputted is
(in the same workbook).

any help is appreciated!

thanks