Text boxes in userforms (VBA)

Stubby · Mar 6th, 2002, 02:06 AM

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 · Mar 6th, 2002, 02:11 AM

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: =TextBox you are parsing Text.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 6th, 2002, 02:06 AM	#1
Stubby Board Regular Join Date: Mar 2002 Location: Lat 51° 23.3 mins North Long 0° 24.7 Mins West Posts: 174	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!!

Mar 6th, 2002, 02:11 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	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: =TextBox you are parsing Text.