Dropdown autofilter vba code

[japie123]

Hello people, i am asking you one more time for help. im a now using this code

Please Login or Register  to view this content.

and in cell B5 i want to have a dropdown to select for one of the values of column B. In this column there are 300 records. but just 8 different. so i want a dropdown with 8 different values for the 300 records. who can help me with a code to add in this code?

Thanks

[Bernie Deitrick]

You can use a macro like this: I have assumed that you list in column B starts in row 12, though I'm not sure why you're only autofiltering up to row 34.

Please Login or Register  to view this content.

[japie123]

It is not working, I get a error 400 if i run this macro, is it also possible to use combofilter for the dropdown? and which code do i need to use.

[Bernie Deitrick]

The macro worked for me - so what line gives the error? Is your worksheet or workbook protected? Is the sheet filtered at the time that you run the code? Does it work in a new workbook/worksheet?