Excel Programming >> 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
> 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
>
>
>
