Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search Button
Help please, I have a excel worksheet with 5000 names on it, I would like to
create a search button on the sheet. I don't want to use the Edit-Find Option. Basically I would like to type a name in a box and click a search button next to the name and then it moves down the speadsheet and highlight the name, help please Regards |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search Button
What you ask will take a macro to perform. If you wish a macro solution,
then post back telling us which column your Name list is in, and someone will help. Vaya con Dios, Chuck, CABGx3 "mica" wrote: Help please, I have a excel worksheet with 5000 names on it, I would like to create a search button on the sheet. I don't want to use the Edit-Find Option. Basically I would like to type a name in a box and click a search button next to the name and then it moves down the speadsheet and highlight the name, help please Regards |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search Button
Hi there, thanks for the reply.
The names exist in too many different rows and colums. Actually I change this speedsheet into webpage so I don't believe a macro would work, do you have any other solution that I can plug into my XHTML page, regards "CLR" wrote: What you ask will take a macro to perform. If you wish a macro solution, then post back telling us which column your Name list is in, and someone will help. Vaya con Dios, Chuck, CABGx3 "mica" wrote: Help please, I have a excel worksheet with 5000 names on it, I would like to create a search button on the sheet. I don't want to use the Edit-Find Option. Basically I would like to type a name in a box and click a search button next to the name and then it moves down the speadsheet and highlight the name, help please Regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command Button Assignment | Excel Discussion (Misc queries) | |||
Runing two macros triggered by a button | Excel Discussion (Misc queries) | |||
Command Button anomalies | Excel Discussion (Misc queries) | |||
FAQ Spreadsheet with search function | Excel Discussion (Misc queries) | |||
Macro to simply bring up the Find dialogue box?? | Excel Discussion (Misc queries) |