Hi All

I am trying to evaluate two textboxes

If TextBox3.Value TextBox2.Value Then
......
.......
Else
........

End If

but I am getting strange results with the above code
Is their a better solution to this.

Regards

Subs

It would help to see what the strange results are, but I have an educated
guess. Do the textboxes contain numbers you want to compare? Textbox values
are strings; an alpha comparison on strings gives different results than a
numeric comparison - to see what I mean try this in the immediate pane:
? "10" "2"
Should show the answer is "False" - alphabetically, the "1" in "10" comes
before "2".
Do it this way:
If Val(Textbox3.Value) Val(Textbox2.Value) Then ...
This converts the text to numeric values for the comparison
--
- K Dales


"Subs" wrote:

Hi All

I am trying to evaluate two textboxes

If TextBox3.Value TextBox2.Value Then
......
.......
Else
........

End If

but I am getting strange results with the above code
Is their a better solution to this.

Regards

Subs

Hi,

In the same way of thinking you can also convert the results to a
certain type and compare then :

If CInt(Textbox3.Value) CInt(Textbox2.Value) Then ...
This converts the text to Integer values for the comparison

Warning : it's also good to check those values BEFORE you make the
comparison.
You can make the check with IsNumeric

Peter