Simple Find Button added to Worksheet?

[Proto]

Hello all, I've done a search, but have not found what I'm looking for
I need a button to be placed on a worksheet so that users can press th
button and then the "Find & Replace Box" pops up (like Ctrl F) o
something simlar.

Example:

I have 1,000 rows, 6 columns. I need a find button so they can enter
part number in and it will take them to that row to view or print out
plot file.

I've tried adding a button, then recording a macro, by pressing th
button, selecting the worksheet, and pressing the "Find" toolba
button. I'm not to familar with macros.

I know, why don't you get them to use the "Find button (binoculars)"
it's like teaching a dog to sit, some learn & some don't.

Any help would be great!

Let me add that I found this site today and it's great!

Thanks,
Proto "Jason

 

[Ron de Bruin]

Use this to show the Finddialog

Application.Dialogs(xlDialogFormulaFind).Show