Simple Find Button added to Worksheet?
 

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

--
Prot
-----------------------------------------------------------------------
Proto's Profile: http://www.excelforum.com/member.php...fo&userid=1595
View this thread: http://www.excelforum.com/showthread.php?threadid=27430

Simple Find Button added to Worksheet?
 

Use this to show the Finddialog

Application.Dialogs(xlDialogFormulaFind).Show


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Proto" wrote in message ...

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 the
button and then the "Find & Replace Box" pops up (like Ctrl F) or
something simlar.

Example:

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

I've tried adding a button, then recording a macro, by pressing the
button, selecting the worksheet, and pressing the "Find" toolbar
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"


--
Proto
------------------------------------------------------------------------
Proto's Profile: http://www.excelforum.com/member.php...o&userid=15950
View this thread: http://www.excelforum.com/showthread...hreadid=274304