Can Combobox linked to Autofilter?

[lnk2013]

First let me say I am new to VBA and I found your website and it has been very helpful!

I have been scowering the web and can't get a clear answer...

Can a combobox be linked to an autofilter? Essentially the combobox would do the exact same thing as the autofilter?

PREFACE:

I am building a report generator with a UserForm.
I have a Userform with 4 Comboboxes. The first is a NAME, 2nd is month, 3rd is a company, and 4th is product number. This data will be drilled down(filtered) using the the comboboxes/autofilter.

Workbook:
Sheet - RawData where data is located. The table has entries that correspond to the 4 comboboxes, but also has other columns for quantity, price etc. A total of 90 columns data that has multiple similar entries / repeat data.

Sheet - CopyData - Sheet where data that has been Autofiltered/Drilled down will be copied to in order for reports to be generated.

[jaslake]

Hi lnk2013

Welcome to the Forum!

Sure, you can use the ComboBox entries to filter data. Without seeing your actual worksheet I can only give you the concept. The code to do the filtering would look something like this

Please Login or Register  to view this content.

Change the underlined/bold items to suit.