Userform CheckBox State Filter

[rbirch]

I’m trying to build a user form where an user can select multiple states and have a filter be applied to column A that selects only those states. Below is what I have from help from the community. I tried following this thread (in the link below), but I don’t have a frame control and I don’t know how to change the order of it with the checkboxes
http://stackoverflow.com/questions/1...-a-single-cell
I’m also trying to build a filter for dates in column D in the same user form, but I want to do that by myself.
Thanks again for your help.

[humdingaling]

use an array to autofilter on

Please Login or Register  to view this content.

i left your original code on the file
ps your Userform was missing checkbox41 so i put one in manually

[rbirch]

How do these lines of code work?

Please Login or Register  to view this content.

I'm stepping into the program and I'm trying to figure out how it selects the states.

[humdingaling]

Please Login or Register  to view this content.

i have rewrote the code with some statements

add a watch for MyArr and step thru the code
what MyArr grow with the amount of the checkbox's you have ticked

a very basic and simple explaination of dymanic array
http://www.excel-easy.com/vba/exampl...mic-array.html

a more in depth link here
http://www.cpearson.com/excel/vbaarrays.htm