Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search Box and 13 sheets
I am so new to programming, but here is what I need. From a main page I have
a search box, by clicking the search box I want it to find the key word in all 13 sheets, place the results in a seperate worksheet....... or at least find that specific word in all 13 sheets and the use can just go through all the results. I hope that makes sense. Please, if you can help I am desperate. Thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search Box and 13 sheets
What do you mean by 'results'?
"1stimer" wrote: I am so new to programming, but here is what I need. From a main page I have a search box, by clicking the search box I want it to find the key word in all 13 sheets, place the results in a seperate worksheet....... or at least find that specific word in all 13 sheets and the use can just go through all the results. I hope that makes sense. Please, if you can help I am desperate. Thanks, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search Box and 13 sheets
Results meaning all instances of they keyword or I could simply do with
locating the keyword throughout all 13 sheets. Like the similiar to a pdf form whenyou search for a keyword the results show where it is located by the highlighted word. I hope that makes sense. "JLGWhiz" wrote: What do you mean by 'results'? "1stimer" wrote: I am so new to programming, but here is what I need. From a main page I have a search box, by clicking the search box I want it to find the key word in all 13 sheets, place the results in a seperate worksheet....... or at least find that specific word in all 13 sheets and the use can just go through all the results. I hope that makes sense. Please, if you can help I am desperate. Thanks, |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search Box and 13 sheets
In xl2002+, you could just show the edit|Find dialog and tell the user to click
on the options button and select entire workbook. Or you may want to try Jan Karel Pieterse's FlexFind: http://www.oaltd.co.uk/MVP/ It'll work for all versions. 1stimer wrote: I am so new to programming, but here is what I need. From a main page I have a search box, by clicking the search box I want it to find the key word in all 13 sheets, place the results in a seperate worksheet....... or at least find that specific word in all 13 sheets and the use can just go through all the results. I hope that makes sense. Please, if you can help I am desperate. Thanks, -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search in Multiple Sheets | Excel Discussion (Misc queries) | |||
Search Different Excel Sheets | Excel Programming | |||
Search for word(s) in several sheets | Excel Programming | |||
Search two sheets simultaneously | Excel Programming | |||
Search all sheets | Excel Programming |