Excel Search Box 2

[JeffITman]

Is there a way to place a text box on a sheet and use it as a search box for said sheet?

I have a 900 line sheet and would like to allow my employees to type in an exact number and have the cursor automatically go to the line that the number is on.
the user will open up to sheet 1. Within sheet 1 are 900 lines of information. The first Column (A) has a unique number that none of the other 899 lines have. The user will know which number they are looking for, i just though that i would make it easier to have a "find" field at the top of the sheet rather than the user having to open up that feature.

 

[JeffITman]

thanks so much PHV!

 

[WinblowsME]

Private Sub CommandButton1_Click()
   ActiveSheet.Range("A1").Select
   Application.SendKeys "^f"
End Sub