View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JasonK[_2_] JasonK[_2_] is offline
external usenet poster
 
Posts: 18
Default 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