User Form TextBox

markoakes

Active Member
Joined
Jan 5, 2004
Messages
325
Is there any way to set the Number Format in in a TextBox Control? I would like to display 4 places after the decimal point. Example: 23.1230 not 23.123
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

XLGibbs

Well-known Member
Joined
Feb 25, 2005
Messages
2,446
Format

"##.####0"

This would be in the properties of the textbox control, or in the

you can format it :

Format(Textbox1.Value, "##.####0")
 

Watch MrExcel Video

Forum statistics

Threads
1,118,318
Messages
5,571,524
Members
412,399
Latest member
Amoldavskii
Top