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

officeclerk · 04-14-2012, 08:42 AM

I have a basic userform with textboxes for data entry. Is it possible to format the data so when it goes to the spreadsheet, that it will stay in number format instead of changing the cell format to text?

This is what they currently look like.

Code:

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

Can this be done by changing the textbox properties?

Thank you.