I need to make a dependant combobox

**grizzlypete44** · 12-01-2011, 09:55 AM

Hi all,

I have a project where I want to use two (at least) comboboxes to filter information. The seconds list will be based on the first.

This seems to be a basic thing and I have seen code snippets but nothing that has worked to be honest.

A basic example would be very welcome.

I can provide the input tables if necessary.

Regards,
Pete

**arlu1201** · 12-01-2011, 09:57 AM

Try this link - http://www.contextures.com/xldataval02.html

**grizzlypete44** · 12-01-2011, 10:44 AM

You cant use comboboxes? The reason I ask is that I will have to filter on the value that is stored in the second box. Which as far as I can tell i cant get from a validation box.

**arlu1201** · 12-01-2011, 10:54 AM

I am not able to understand your requirement. Maybe you can post a sample workbook.

**grizzlypete44** · 12-01-2011, 11:12 AM

ok,

Ill try to explain. We have a table of products. We want people to be able to filter this table on their own without seeing or editing the orignal table. The table is made up of 9 categories each with between 3 and 9 subcategories.

sooo, What I want is them to first pick a category using a combobox. Then based on their first response choose a specific subcategory in the second. then they hit a execute button and it does the filtering and produces a list which they can further play with.

Ideally, I would use two comboboxes and then a commandbutton to get the first list.

I have included the spreadsheet that im working with currently. this is the data made to do the filtering. the actual product data is in a different table.

Hopefully, its a bit clearer.

Regards,
Pete

**arlu1201** · 12-02-2011, 02:55 PM

Yeah 2 dependent dropdowns will work in this case. For the button you need a macro that will filter the results for you. The results can be filtered on another sheet if you do not want the users to disturb the original sheet.