Split the results of a search in to 2 list boxes

Hi everyone. I am trying to split the results of a search into two separate listboxes. The user would enter the date in the textbox above "Click here to see class for selected date". They would then click on the command button. I need the results from that date search to be divided into the appropriate list bos. The ones that have a Y or Yes in the "Clear" column on the worksheet to go into the listbox marked "Clear". The ones that have a N or NO in the "Clear" column to go into the listbox marked "Not Clear". Thank you for your help

SS number (Column A), Last (Column B), First (Column C)

If you can make that work, that sounds like a good idea

Can you make it so the Combo box doesn't show past dates?

Sorry to be a pain, would it also be possible to filter by column "V". So....it will show all in the ERJ for a certain class date, and all in the CRJ for a certain class date?

Yes the top combo is the search of SSN and it populates the rest of the userform. It doesn't have to be done with option buttons, Do what you think would work better.

Sounds good to me. lets give that a try

Wait, just to be clear, when I put in a date for the class, I need to see the clear and the unclear at the same time.

wow that works great. Thank you so much. Let me test everything and I will let you know

Thank you so much. I will mark this as solved.

Sorry, I found one problem. I had it set up that if I clicked on the results in the list box, the information would populate the userform with the information. I guess that went away with not using the results page. How can I fix that using what you have done.

Thank you very much. I think we got it. Have a great day

Is it possible to take the results from the "Cleared" listbox and put them in an email?

Yes the contents of the list box + ERJ/CRJ and Class Date. Just a command button anywhere I guess if that will work

Thank you very much. It works great. I may have more later, i hope you will be available to help.

I have one more question. Is it possible to add anther drop box for the search. I would like to add "Division" (Add column X as Division) The order would be ERJ/CRJ-->Division-->Class Date. Thanks

Works Great. Go ahead and add the error checking

It is not filtering by Division when it is putting the results in the listbox. It is putting everyone with that date in the listbox

It works when I use your spreadsheet. When I import the code to my actual sheets I get this error Call cmdClearFilter_Click

It says Sub or Function not defined Call cmdClearFilter_Click

Ops...........it works now Thank you for everything

Well I hope this is the last thing you can fix for me. This should complete this project. I put what I need on the userform. Thanks

I will just add a column for the creation date in the next column.

If you are asking if the check boxes are apart of the other filter you created then that would be no. I need them to be separate

Have you had any luck?

lol Just checking

No I don't need the creation date on the user form. I only want the "Open" to populate when a new record is added. I have it set up (not sure it is set up on the form you have, but it is on the master" to populate when a new SSN is added. The check boxes results should go to the "Not Clear" box. I need it to filter by department, and not clear.

ops, need it to filter by Department, Not Clear, and Open

How is it going?