Help with Macro to Find based on cell Change

[largeselection]

Hi,

I've done a little bit with macros that run on changes within a cell (checkmarks and such).

I'm trying to have one that basically executes a find based on the cell value that changes. As it stands now I have a sheet conditionally formatted so that when I put in an ID number in cell B17 it will highlight the entire row where the value in B17 is equal to the value in the cell in column A.

What I'd ultimately like to have happen is for it to execute a find and "jump" to that location. So I'd like to be able to type in ID# 1 into B17 and then have it automatically jump to that row (which will be highlighted yellow).

Sorry if this is confusing please let me know if you have any questions! THANKS!

 

[rs2k]

This should get you started, right click the ws tab and pate this code in;

Private Sub Worksheet_Change(ByVal Target As Range)
Cells.Find(What:=Range("B17").Value, After:=ActiveCell, LookIn:=xlFormulas).Activate
End Sub

Cheers
Colin