View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Proto[_2_] Proto[_2_] is offline
external usenet poster
 
Posts: 1
Default 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