vba userform textbox formatting

[ktorres]

How can I maintain decimals in a textbox but only display in this format: "#,###"?

For example, the user inputs a cost estimate of 1,300 for the year so the Jan - Dec text-boxes are populated with 108 but the real number is 108.3333 but when I have the textbox save the data back in the spreadsheet it is only saving 108. Any ideas?

 

[Tinbendr]

No. Textbox boxes are strings and however you display them is their value. However, you can store the value in the Tag property, then format the Tag property to the textbox.

Me.TextBox1.Tag = MyNum
Me.TextBox1 = Format(MyNum, "#,###")

 

[ktorres]

No. Textbox boxes are strings and however you display them is their value. However, you can store the value in the Tag property, then format the Tag property to the textbox.

Me.TextBox1.Tag = MyNum
Me.TextBox1 = Format(MyNum, "#,###")

Thanks! I ended up using a more complicated work around by calling the calculate sub then saving the data so the user will see the nice numbers but the model saves the exact number.