Displaying results based on Combo box value EXCEL 2010

**mizacasa** · 01-23-2012, 01:28 AM

I have a problem with using a combo box in Excel 2010.
I have created two combo box. One of them is displaying a list of location while another one is displaying a list of occupation.
I need to display results from an employee table when user selects both of the options from the combo box.
How do I do that? I can't read the value stored inside combo box.
Thanks !

**john55** · 01-23-2012, 01:35 AM

hi,
I'm not sure what you want, could you upload a test file with yr comboboxes and some examples and the result you want?
maybe someone might have a solution for you!

**royUK** · 01-23-2012, 01:37 AM

Simpler to use Data Validation - the List feature

**mizacasa** · 01-23-2012, 01:55 AM

Hi there.
I have attached a file at my post. please take a look at it. hope you can help!
Thanks.

**royUK** · 01-23-2012, 02:02 AM

What's wrong with using AutoFilter?

**mizacasa** · 01-23-2012, 02:09 AM

I really don't know. If i can, i would LOVE TO USE AUTOFILTER. but, my homework has to do in the other manner.
I wouldn't burden myself if I can use autofiler.