Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
input 7 in a cell in EXCEL 2000, it will automatically change to 8 | Excel Discussion (Misc queries) | |||
Formatting to show 0 as first number in a cell when input | Excel Worksheet Functions | |||
format cell to know number of another cell automatically | Excel Worksheet Functions | |||
automatically update a number in cell when template opens | Excel Discussion (Misc queries) | |||
Can I make the number in one cell automatically appear elsewhere? | Excel Worksheet Functions |