Number format in Textbox on userform

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Number format in Textbox on userform

FAQ

Thread Tools

Display Modes

04-14-2012, 08:42 AM

officeclerk officeclerk is offline

Windows 7 64bit Number format in Textbox on userform

Office 2007

Novice

Join Date: Apr 2012

Posts: 2

Number format in Textbox on userform

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Custom Number Format for Chart	deadrxn24	Word	4	03-18-2012 05:38 PM
custom number format: change thousands separator	Ward	Excel	1	06-07-2011 08:18 PM
Textbox Number changes when I open Word	t0m46	Word VBA	0	09-07-2010 05:46 AM
Numbering, defining new number format	nrschmid	Word	0	12-30-2009 03:04 PM
Default Number Format	boutells	Excel	1	05-20-2009 02:46 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:18 PM.