Need help with macro for filtering worksheet data based on combobox control

[preetypj]

Hi folks,

I am new to vba coding and struggling with a simple task.

The requirement is that I have an excel document with two worksheets. One of the worksheet has just got a combo box and the other worksheet has data.

The data in worksheet contains columns out of which one column is Year.

I want the data sheet to be filtered based on the year chosen in combo box.

Will really appreciate if someone could help me.

Thanks
Preeti

 

[skorpionkz]

I am not sure if I understood you correctly. First sheet has Combobox? do you mean combobox from the macro or you just created some kind of menu with drop down menu in this sheet?

 

[preetypj]

I am not sure if I understood you correctly. First sheet has Combobox? do you mean combobox from the macro or you just created some kind of menu with drop down menu in this sheet?

Hi,

I have inserted an ActiveX control - Combo box in the first worksheet. I want to assign a macro that filters the data in my next worksheet based on the Year value chosen in combo box click.

Thanks

 

[skorpionkz]

check this tread please

http://www.mrexcel.com/forum/excel-...box-value-visual-basic-applications-code.html