Finding a record using multiple combo boxes as my search criteria

[sdg8481]

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]

You could use the built-in AutoFilter feature, which allows you to
either select an item from a dropdown list, or select Custom, and type
criteria. There are instructions in Excel's Help, and here:

http://www.contextures.com/xlautofilter01.html

 

[sdg8481]

Yeah i was aware of this option, but i really wanted to use combo boxes or
atleast a cell as my search cirteria.

 

[Debra Dalgleish]

There are sample files on my site that may help you get started:

http://www.contextures.com/excelfiles.html

Under 'Filters", look for 'Product List by Category' and 'Filter Rows
for Text String'

 

[sdg8481]

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

 

[Debra Dalgleish]

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]

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

 

[Debra Dalgleish]

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

 

[Debra Dalgleish]

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