Text box display with 2 decimal point.

Hello every one,

I have a text box on a userform.

The text box is populated with a number which is generated by a figure which is in column "E" in 2 decimal point.

but the result in a text box can't show decimal point.

Ex. in "E5" has figure 60000.00 but in text box it's display 60000
in "E6" has figure 12500.00 but in text box it's display 12500

Is it possible to make the "result" in text box whole number with 2 decimal point?

The text box is named "txtfdamount".

Thanks.

Hi,

How is the textbox actually populated? Is it linked to the cell or done through code?

What if you set the textbox.text to "= Cstr(Sheet(1).Cells(2,5).Text)", does this solve your issue?

HTML Code: 

What should happen (not tested) is the cell value will be converted to text and therefor not rounded like it would be if it were a integer or double.

*--EDIT--*
I just tested my code and I was incorrect :P

Kasan has the correct answer

Rather than use the Control Source property of the textbox - which I assume is the case, use the UserForm Initialise event

Please Login or Register  to view this content.

Originally Posted by xlnitwit

Hi,

How is the textbox actually populated? Is it linked to the cell or done through code?

Done through code

Then I believe you already have several working answers.