Evaluating a number in a textbox

[birdieman]

If I wanted to test if the NUMBER in a textbox is greater than 50, which of the following is correct/accurate, or are they the same?

If Val(TextBox5) > 50 Then....

or

If TextBox5.Value > 50 Then ...

If neither are correct to evaluate a NUMBER in a textbox, then what is correct. thanks

 

[Rick Rothstein]

If I wanted to test if the NUMBER in a textbox is greater than 50, which of the following is correct/accurate, or are they the same?

If Val(TextBox5) > 50 Then....

or

If TextBox5.Value > 50 Then ...

If neither are correct to evaluate a NUMBER in a textbox, then what is correct. thanks

I would affix the Value property to that first one as well. Both of those will function the same. In the second one, VB will coerce the text number to a real number (automatically and behind the scene) in order to perform the mathematical comparison.

 

[birdieman]

If all of my textboxes deal with numbers, would the above also apply when I am saving contents (which is always a number) to a spreadsheet, ie, use "textbox5.value" ?

Would I ever refer to a TextBox containing numbers as Textbox5.Text? (If this question has many "depends on" responses, no need to waste your time answering it.)

thanks for the response

 

[Rick Rothstein]

If all of my textboxes deal with numbers, would the above also apply when I am saving contents (which is always a number) to a spreadsheet, ie, use "textbox5.value" ?

Would I ever refer to a TextBox containing numbers as Textbox5.Text? (If this question has many "depends on" responses, no need to waste your time answering it.)

The contents of a TextBox is text, never numeric... VB coerces the text number to a real number when you use it in a mathematical operation so that it can complete the mathematical operation. As for the Text property question, the help files for the Text property says this in the Remarks section, "For a TextBox, any value you assign to the Text property is also assigned to the Value property" and, while it does not say so for the Value property explicitly, the reverse appears to be true as well.