Microsoft Office Forums - View Single Post - [Solved] Number format in Textbox on userform

Colin Legg · 04-17-2012, 01:23 AM

Textboxes contain string data types. If your users are entering numbers then you can explicitly convert the string into a number (numbers in worksheets are always double data types), for example:

Code:

Private Sub TextBox1_Change()
    Sheets("Sheet1").Range("B25").Value = CDbl(Me.TextBox1.Value)
End Sub

or

Code:

 
Private Sub TextBox1_Change()
    Sheets("Sheet1").Range("B25").Value = Val(Me.TextBox1.Value)
End Sub

If that's what you need then you need to be very careful about what the user may enter into the textbox. You might want to research restricting the characters the user can use to 0 through to 9.