Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need a simple loop with a 4+ row added in. | Excel Discussion (Misc queries) | |||
why can't excel do a simple find and copy row from a worksheet to. | Excel Worksheet Functions | |||
Find button on worksheet | Excel Programming | |||
Find button in excel worksheet | Excel Programming | |||
Find button in excel worksheet | Excel Programming |