trouble comparing a value in a text box with a variable
 

i've got a userform with a text box.
when the user inputs numerical data in the text box, i need the macro
to compare that number with a number attached to a variable.

both the text box number and the variable numbers match, but the macro
is telling me they don't. i believe it's because the textbox is
formatted as text and not as a value. how do i make the text in the
box read as a number so that i can compare with a variable?

the text box is named "checks" i tried:

if checks.text = x then .......
and
if checks.value = x then.......

but neither work.

thanks in advance,
jasonk

trouble comparing a value in a text box with a variable
 

Try this

if CInt(checks.text) = x then .......
and
if CInt(checks.value) = x then.......

Note:
CInt is you want to convert the value of the text box to INTEGER.

trouble comparing a value in a text box with a variable
 

Just some added information
You can also use

clng to convert to long
csng to convert to single
cdbl to convert to double.

Depends on what type of number you have.

You can also look at the val function

if Val(checks.text) = x then

--
Regards,
Tom Ogilvy



" wrote:

Try this

if CInt(checks.text) = x then .......
and
if CInt(checks.value) = x then.......

Note:
CInt is you want to convert the value of the text box to INTEGER.

trouble comparing a value in a text box with a variable
 

thanks arthur
that worked perfectly.
greatly appreciated.
jasonk

On 10 Apr 2006 01:57:30 -0700, wrote:

Try this

if CInt(checks.text) = x then .......
and
if CInt(checks.value) = x then.......

Note:
CInt is you want to convert the value of the text box to INTEGER.