Macro to be used with Combo box

K

kd

Hi,

I am looking for a macro to activate the item from the dropdown of the
combobox and filter its results in the respective coloumns.

For eg.

If my combo box has following drop down items
ITEM A
ITEM B
ITEM C
ITEM D
ITEM E

and I choose ITEM D from the dropdwon.

I have other sheets in the same workbook and each of them has a coloumn with
the above items (Item A, Item B, Item C, Item D and Item E)

What I want?
When I choose an Item (Item D in the above example) from the dropdown, other
sheets are filtered according to that selection (Item D).

Is that possible?

Thank you for any help.
 
B

Bob Phillips

Something along the lines of

Worksheets("Sheet1").Columns(1).Autofilter Filed:=1,
Criteria1:=ComboBox1.Value

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Top