Textboxes
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
|