Crt F (im trying to create a find box within excel)

[Luke1690]

im trying to create a find/search box within excel that will jump to the location of the exact number entered into the box.

i don't want to highlight the box, so not conditional formatting. and i don't want to pull the found data to another location.
i just want to jump to the location on the sheet where the exact data match's.

pretty much (crt f) or the (find and select tab), i want this embedded on my workbook, so dummies can use it.

is this possible?

excuse the poor grammar and thankyou in advance.

 

[bebo021999]

What exactly do you want?
A pop up inputbox, ask user to input some text: "A1" then cell A1 active, or "student" then move to cell with textstring: "I am a student" ?

 

[Luke1690]

thanks for your reply. I've found something that i can use.
i created a button and used the below code.

Sub MyFind()
Application.Dialogs(xlDialogFormulaFind).Show
End Sub

this opens the find window.

not exactly what i wanted but it will do.

i wanted to have a text box with a find button across two cells that when text was entered in the text box and find button was clicked it would jump to the location on the sheet that matches the specific text.

 

[Luke1690]

What exactly do you want?
A pop up inputbox, ask user to input some text: "A1" then cell A1 active, or "student" then move to cell with textstring: "I am a student" ?

yes