Text boxes in userforms (VBA)

[Stubby]

Can any help me with this problem. I have a userform created in VBA which collects numeric data via a text box. However when I post the values from the text box they appear as text not numbers. What code do I need to stop this as its driving me up the wall!!

 

[Dave Hawley]

Hi

Excel has many Conversion function, such as

CInt(), cLng() and Cdbl()

But you should just be able to parse the text number to a numeric variable such as:

Dim iMyNumber as Integer
iMyNumber=TextBox1.Value

Also the default Property for a Textbox is Text, so if just use: <Whatever>=TextBox you are parsing Text.