search feature in Excel

[Sektet]

Hello all,

I have a little project to do and would like to get some help on usin
the search feature in a simple worksheet.

I have a worksheet that contains over 25 excel sheets, each with lot
of information.

I need to make a search feature/button, so people using it can use th
first sheet named Search to locate their keywords in the 25 sprea
sheets and growing.

Something to look like this;

Label:Enter Search Words: ________________


Click here t
search/button

Can you point me to some resources on the issue or provide exampl
code.

Thank you in advance,

sekte

 

[Dave Peterson]

You may want to look at how Jan Karel Pieterse's did it in his FlexFind:

You can find it here:
http://www.bmsltd.co.uk/MVP

(in fact, I'd use that one and just tell the users to do one keyword at a time.)

 

[Sektet]

this is great Dave, so far it does what I want to do and more.

many thank