Use numeric data from a textbox on an userform

E

Excel

I have an userform that has 4 textboxes. The user inputs numbers in
these boxes. I transer these values to another sub. However it
transers the number as text and not as a number. I am doing a logical
comparison (variable1<variable2) and it is not working because it is
comparing a number with a text. What do I need to do?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set focus (and select text) on a text box on a modeless userform? 0
Automatically Combine Cell Contents and Delete Rows 0
Copy value of textbox to clipboard for use in another application 5
Finding the proper style field and the numbered paragraph value within the style 0
Date showing as numbers in Textbox on Userform 2
Extract text from a "textbox" 7
Odd behaviour with a userform 0
Finding the right style field in VBA 0

Top