Textboxes  
Author Message
bobburk3





PostPosted: Tue Sep 27 06:52:03 CDT 2005 Top

Excel Programming >> Textboxes

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

Excel19  
 
 
KDales





PostPosted: Tue Sep 27 06:52:03 CDT 2005 Top

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





PostPosted: Wed Sep 28 14:49:52 CDT 2005 Top

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