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,

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,

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,

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