Create a user form with a multi-column list box

**duugg** · 07-12-2009, 08:25 PM

Hello all,

I had a macro previously solved here by protonleah (thanks protonleah)

Here's the link...

http://www.excelforum.com/excel-prog...-criteria.html

Here's the code:

Please Login or Register  to view this content.

I however, would like to modify this code to instead, bring up a list of states that can be selected via checkmark inside a checkbox.

Keep in mind that my data will not actually be states, this is dummy text and data pulled would be from the column named "Date Opened".

Pressing "Cancel", "OK" or "Select All" would automatically keep all "states"

I've attached a sample picture of what I am looking for.

Is this possible?

thanks much

**duugg** · 07-13-2009, 09:42 PM

bump, no response

**Palmetto** · 07-13-2009, 10:19 PM

It would be more helpful if you posted your workbook so that your structure and data are available.

Here is a general outline of how to proceed:
You will need to create a user form with a multi-column list box set to use MultiSelectMulti property and probably a separate check box for "all". The RowSource should be a list of "states" with text that exactly match the values in your data.

Next, you'll need to loop through all of the check boxes in the form to test which ones are checked and match them against the rows in the applicable column and delete all matching rows.

All of the checked boxes could probably done as an array.
Preferably, your data is a dynamic named range to automatically accommodate changes in size from addition and deletion of rows.