Sorry -- the code is on the Sheet2 ("Data") module.

Debra Dalgleish wrote:
That's an add-in that comes with the Excel program -- it's not something
that I created, or have a password for.

However, you shouldn't need to access the code for that add-in. If you
want to modify the code in my sample workbook, you can access the code
in Module1 of the AdvFilterSearchWord.xls project

sdg8481 wrote:

yes sorry this is what i'm seeing ... is it possible to send me the
password for this.

"Debra Dalgleish" wrote:


There's no add-in file connected to my workbook. Perhaps you're
seeing FUNCRES.XLA, which is a file from the Analysis ToolPak.

sdg8481 wrote:

Hi Debra,

Thanks, i downloaded the advfiltersearchword spreadsheet from your
website and this is exactly what i'm looking for, however when i try
to copy it and adapt it to my DB i need the password for the
FUNCLAS.XLA that you set up

"sdg8481" wrote:



Hi,

I hope this can be done. What i have is a large range of data with
many columns like surname, dob, town, etc.. and many rows.

What i would like to do is to search and filter this range to show
only records found that match criteria i have chosen in using
multiple combo boxes. I would also like the combo boxes to contain
a all the options in the range but also the facility to manually
type in the criteria.

Can anyone help?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html







--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html