On a UserForm, how do I get a Lable or TextBox to show text in a number format. For example, I want a Lable to show the number from cell A1 in my Excel Spreadsheet with a comma in it ("#,##0" format). In Visual Basic, there is a property to set for it, but in VBA, there doesn't seem to be one. Any suggestions?
Thanks, Tom
Sat, 18 Jun 2005 03:43:25 GMT
Kim Mitchel #2 / 3
Number Format in UserFrom Lables and Text Boxes
I would use the Format() function: Label1.Caption = Format(Range("A1"),"#,##0")
Kim
Quote:
> On a UserForm, how do I get a Lable or TextBox to show > text in a number format. For example, I want a Lable to > show the number from cell A1 in my Excel Spreadsheet with > a comma in it ("#,##0" format). In Visual Basic, there is > a property to set for it, but in VBA, there doesn't seem > to be one. Any suggestions?
> Thanks, > Tom
Sat, 18 Jun 2005 11:56:20 GMT
Tom #3 / 3
Number Format in UserFrom Lables and Text Boxes
Thank you...that is exactly what I needed.
Quote:
>-----Original Message----- >I would use the Format() function: >Label1.Caption = Format(Range("A1"),"#,##0")
>Kim
>> On a UserForm, how do I get a Lable or TextBox to show >> text in a number format. For example, I want a Lable to >> show the number from cell A1 in my Excel Spreadsheet with >> a comma in it ("#,##0" format). In Visual Basic, there is >> a property to set for it, but in VBA, there doesn't seem >> to be one. Any suggestions?
Number Format in UserFrom Lables and Text Boxes