Listbox in userform to populate with all rows containing the Date today AND 2 weeks prior

Hi all!!

I have a userform with a listbox that populates depending on the date in column 8. Currently the listbox populates only with the rows containing TODAY'S date. I need it to populate with the rows containing today's date and the dates in the 2 weeks before today.

My current code is as follows:

Please Login or Register  to view this content.

I have tried: on the Criteria1 part of my code :

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

But it keeps telling me to debug it..

Any ideas would be greatly appreciated! Thanks!

Sorry, do you mean this bit?

Please Login or Register  to view this content.

As I still need it to search this column, I just want it to populate the dates from this column that are today AND within 2 weeks prior to today. Sorry if this was unclear in my explanation, or if I've just completely misunderstood your suggestion, where am I going wrong?

Ahh fab, I stuck it in an array and it works fine now!! Thanks for your help!