kdberg
01-08-2009, 10:26 PM
I have a UserForm in Excel 2007 with a textbox that is bound to a worksheet cell. The worksheet cell is formatted to hold a number and to display it as fixed point with one decimal point precison. As an example it might contain the value 1, and will display it as 1.0 as it should.
The problem I have is that I can't get the textbox on the form to display it as fixed decimal with one decimal point precision. If the worksheet cell is an integer value (such as 1.0) the textbox will display 1, not 1.0.
If the worksheet cell value is not an integer, say 2.1, then the text box will also display 2.1. So the problem is only with integer values. Is there a way to force the textbox to format the way that I want? The valid range of values is 0 to 999.9 .
The problem I have is that I can't get the textbox on the form to display it as fixed decimal with one decimal point precision. If the worksheet cell is an integer value (such as 1.0) the textbox will display 1, not 1.0.
If the worksheet cell value is not an integer, say 2.1, then the text box will also display 2.1. So the problem is only with integer values. Is there a way to force the textbox to format the way that I want? The valid range of values is 0 to 999.9 .