Textbox doesn't seem to recognize that it has the same value as the cell!

[Oliver Dewar]

OK I've come across one extremely odd case for the X(cel)-files.

This is something I have done over and over in this project except for one difference... this cell has a formula in it, not just a value as in the others.

in the cell in question I have a formula that works well. Here's the formula:

=IF($Y39="","",IF($Y39="Child","Child",IF($Y39="Adult","Adult",DATEDIF($Z39,TODAY(),"y")+$Y39)))

this code works out the age of someone from a number and date of input or the words Child or Adult.

the cell in question (A1) returned 13.

in textbox1 on a userform I have a textbox1_change as follows:

Textbox1_change()
if textbox1.value = range("A1").value then
msgbox"match"
End if
End Sub

I type in the number 13 into textbox1 and... nothing happens!

Now, I have found a workaround in that I copy the value of the formula to another cell on the sheet and the contents of the textbox to the next cell and compare those... and it works!

So really my question is... what is going on? Why doesn't 13 in textbox1 = 13 (the result of the formula) in cell A1?

Any Moulders out there?

 

[VoG]

Textboxes contain text not numbers. Try

If Val(textbox1.Value) = Range("A1").Value Then

 

[Norie]

Well the result of the formula might be a number, like 13 for an example.

Textbox's hold text, so comparing them might not work.

If Val(TextBox1.Value) = Range("A1").Value Then

 

[Oliver Dewar]

You guys are totally onto it! Fixed it like a dream (and works for text as well)