is userform textbox input by user default TEXT?

**JohnSeito** · 03-31-2009, 09:06 PM

If it is how do I convert the user input for the text box field as number. thx

**Paul** · 03-31-2009, 10:10 PM

Hi John,

It depends on where your textbox is. If it's a textbox on a sheet, and it is linked to a cell (let's say A1), then you could use the VALUE() function to convert it to a number, e.g.

=VALUE(A1)*60

If it is on a UserForm, and you're referencing it via VBA, use the Val() function to convert it, e.g.

Please Login or Register  to view this content.

Although myVal = Textbox1.Value * 60 should also work.

Hope that helps!

**royUK** · 04-01-2009, 02:45 AM

The default is a string. There are are several options depending on the numeric type required, Use the Type Conversion Functions

CCur(TextBox1.Value) - Currency
CDbl(Me.TextBox1).Value - Double
CInt(Me.TextBox1.Value) - Integer
CDate(Me.TextBox1).Value-Date

See the VBA Help files

**JohnSeito** · 04-01-2009, 07:46 AM

pjoaquin and royUK

thanks for the help. So far I don't have that string problem any more. I am still working on the program and well see it any other issues arise. As of now the string problem is resolved. thanks.