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-16-2012, 10:48 PM

jolivanes

Windows XP Number format in Textbox on userform

Office 2007

Advanced Beginner

Join Date: Sep 2011

Posts: 91

jolivanes will become famous soon enough

You could try any of these.

Code:

Private Sub UserForm_Initialize()
TextBox1 = Range("B1").Value
TextBox2.Value = Format(Range("B1"), "$###.00")
TextBox3 = Sheets("Sheet1").Range("B1").Text
TextBox4.Value = Format(Range("B1"), "$###.##")
TextBox5.Value = Format(Range("B1"), "$0,000.00")
End Sub

« 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 02:40 PM.