VBA Date Comparison, and then some...

I have a list of accounts with established dates in column B. I'm using a form to create a report. The report should show only accounts with an established date after October 1 of the year selected in a combo box in the form. I was thinking of using a Do...Loop to look at each row, compare the established date to October 1 of the year chosen, and clear the rows where the date is less than the 10/1 of the chosen year. I think I was doing good until it came time to compare the date to 10/1 of the chosen year.

Here is what I have, but it isn't working, can anyone help?

Please Login or Register  to view this content.

Deleted, OP added code tags as requested.

Can you provide more of the code? And a better description of "not working"? Do you get an error?

Here is a possibility...

Please Login or Register  to view this content.

Note that if you want to delete the rows instead of just clearing them, you'd have to go from bottom to top, meaning the loop would change to

Please Login or Register  to view this content.

Try to avoid using strings to compare dates.... depending on cell formats that can cause unexpected results (which is why I used a variable in my post, set the date controlling year/month/day input and then compared to that). Are you sure when
rowNum = ActiveCell.Row
colNum = ActiveCell.Column
takes place, that the correct cell is active?