Looking up some dates not working

[kelly mort]

With Sheet1.Range("C7:C1007")
    Set rngFind = .Find(what:=CDate(Me.Rw2.Text), After:=Sheet1.[C1007], LookIn:=xlValues, lookat:=xlPart, SearchDirection:=xlNext)
 End With

This is a line in my code

Some dates are not picking.

From 20th upwards does not work. But below 20th works fine. Can someone point out what I am doing wrongly? Me.Rw2 houses the dates

The date is in dd-mm-yy

 

[MARK858]

What is Me referring to? what is Rw2? are you sure it is everything below the 20th that is correct and not below the 13th?

 

[kelly mort]

What is Me referring to? what is Rw2? are you sure it is everything below the 20th that is correct and not below the 13th?

Me is referring to the userform. Then Rw2 is a textbox on the userform.

So far from 1st to 19th is working fine. I see the problem only from 20th upwards.

Regards

 

[MARK858]

Thanks for the update on the setup, at least now I know that there is a userform and a textbox so now I can test

 

[MARK858]

The below works fine for me if I am typing in the same format in the textbox as in the sheet.

With Sheet1.Range("C7:C1007")
    Set rngFind = .Find(what:=Me.Rw2.Text, After:=Sheet1.[C1007], LookIn:=xlValues, lookat:=xlPart, SearchDirection:=xlNext)
End With
rngFind.Interior.ColorIndex = 6
End Sub

CDate puts the search term as dd/mm/yyyy

 

[kelly mort]

The below works fine for me if I am typing in the same format in the textbox as in the sheet.

With Sheet1.Range("C7:C1007")
    Set rngFind = .Find(what:=Me.Rw2.Text, After:=Sheet1.[C1007], LookIn:=xlValues, lookat:=xlPart, SearchDirection:=xlNext)
End With
rngFind.Interior.ColorIndex = 6
End Sub

CDate puts the search term as dd/mm/yyyy

It's still not working for me. My worry is why only from 20th upwards not working.

It's strange

 

[MARK858]

Sorry but I can't be of any help as I can't reproduce your results (I even tried changing my regional settings to dd-mm-yy to see if that caused it but not on my computer).

 

[kelly mort]

Sure, I understand that. I really appreciate your time. I will keep trying things to see what will work.

Regards

 

[Akuini]

Sure, I understand that. I really appreciate your time. I will keep trying things to see what will work.

Regards

You can upload your sample workbook (without sensitive data) somewhere (maybe via dropbox or google drive), then put the link here.
Make sure your sample will reproduce the error you described above.