Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Having trouble getting MATCH to work with a variable lookup array | Excel Worksheet Functions | |||
Trouble comparing to subtotals | Excel Programming | |||
variable trouble | Excel Programming | |||
Trouble with variable type | Excel Programming | |||
Trouble setting variable as filename with date | Excel Programming |