ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Format a txt box. (https://www.excelbanter.com/excel-programming/322599-format-txt-box.html)

JT[_2_]

Format a txt box.
 
Users enter info in a text box; which is later displayed
in a second text box. One of the text boxes is for
amounts.

Currently, if they enter 10, that is how it is displayed
in the second text box. Is there an easy way to ensure
that amounts are always displayed with 2 decimal points in
the second text box (10.00)?

Thanks for the help

Tom Ogilvy

Format a txt box.
 
Textbox2.text = format(cdbl(Textbox1.Text),"#0.00")

--
Regards,
Tom Ogilvy

"JT" wrote in message
...
Users enter info in a text box; which is later displayed
in a second text box. One of the text boxes is for
amounts.

Currently, if they enter 10, that is how it is displayed
in the second text box. Is there an easy way to ensure
that amounts are always displayed with 2 decimal points in
the second text box (10.00)?

Thanks for the help




Ben

Format a txt box.
 
if hte text boxes are not linked and you are programming the value into the
second one then you can

val1 = textbox1.text
val2 = format(val1,"$0.00")
textbox2.text = val2


"JT" wrote:

Users enter info in a text box; which is later displayed
in a second text box. One of the text boxes is for
amounts.

Currently, if they enter 10, that is how it is displayed
in the second text box. Is there an easy way to ensure
that amounts are always displayed with 2 decimal points in
the second text box (10.00)?

Thanks for the help



All times are GMT +1. The time now is 05:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com