Issue With Certain Dates Not Being Recognised When Searching

Hi

I have a range of dates which I have VBA search through using a command button to find the cell that contains a specific date Im looking for - a date picked from a calendar user-form and placed in a text box. The
The format of the date in the text box is the same as the format of the range, i.e. dd-mmm (or for example 11-feb), and the code instructs VBA to search the cell value.
However this is where I am confused. On searching I can find any date but only those after the 10th of the month, for example 10th, or 17th, or 22nd. But it fails to recognise anything between 01-09. Why is this and is there any solution?

The code from the calendar to the textbox is:

Please Login or Register  to view this content.

and the code to search in command button is

Please Login or Register  to view this content.

This is a works project and was going good until this problem which has brought me to a complete standstill for the last two days. Any help would be gratefully received

Thanks Leith Ross, your solution still refused to acknowledge the dates however your answer did inspire me to make some changes and bingo, sorted.
Basically I changed the calendar code for the date format to dd/mm/yyyy and changed the search code to look in formulas.
Thankyou for taking the time to help me.

OMG now Iv discovered another problem!!!!
Every date Iv tested is working fine apart from 01/01/2020, which for some reason is jumping to 01/11/2020.
Whats going on??

Hello el-paso

Originally Posted by el-paso

OMG now Iv discovered another problem!!!!
Every date Iv tested is working fine apart from 01/01/2020, which for some reason is jumping to 01/11/2020.
Whats going on??

Your choice of xlFormulas for the LookIn parameter is an excellent choice for finding a date. With the FIND command, don't forget to also specify the value of the LookAt parameter and the value of the After parameter.

Replace

Please Login or Register  to view this content.

by

Please Login or Register  to view this content.

cheers docmarti for it to be something so simple as the lookat feature!