textbox strings

[Jaye7]

I have the following strings script to put values in text boxes.
This script is just a example script.
If the value in the strings i.e. strings(0) is a number how do I store it as a number in the textbox and not text.

Dim Strings() As String
Strings = Split(textbox1.Value)

me.textbox2.value = strings(0)
me.textbox3.value = strings(1)

 

[ParamRay]

.
.

In VBA you can use the following functions to convert expressions to another data type:

CBool - Converts an expression to a Boolean data type
CByte - Converts an expression to a Byte data type
CCur - Converts an expression to a Currency data type
CDate - Converts an expression to a Date data type
CDbl - Converts an expression to a Double data type
CDec - Converts an expression to a Decimal data type
CInt - Converts an expression to an Integer data type
CLng -Converts an expression to a Long data type
CSng - Converts an expression to a Single data type
CStr - Converts an expression to a String data type
CVar - Converts an expression to a variant data type

 

[ztodd]

you could also probably just use the val() function.

 

[mikerickson]

TextBoxes can only contain strings, they can't contain numbers.
They can contain numerals, which are strings, like "23", but not a number, like 23.

 

[Jaye7]

Thanks for your help everyone, much appreciated.