Comparing a date on sheet with a date in textbox

[Oliver Dewar]

Hi All!

I have a little comparison on a userform:

If TextBox72.Value = Cells(ActiveCell.Row, "AJ").Value Then
msgbox "Dates are the same"
else
msgbox "Dates are different"
end if

Where both textbox72 and Cells(ActiveCell.Row, "AJ").Value are dates.

The problem is that it is returning as false even when the dates are the same.

I've tried putting Val(textbox72.value) as you would for a number but same result.

What do I need to change?

Thanks in advance.

 

[Oliver Dewar]

Ok - Just worked out the answer for myself.

The cell was formatted as a date. I simply changed it to be formatted as general. Now the comparison works as it should.

Thanks!

 

[Oliver Dewar]

*Update

Had some more problems, until I changed the cell format to text.

Now no probs at all.