Convert number to text and add comma separator for thousands

[prahz]

I have a Text Box in a User Form that I am creating. The Text Box's
value is set to a number without decimals.

For example:
Dim rents As Long
rents = 4102
rentsTxtBox.Value = rents

So when the number passes to the Text Box, I want it to display like
this: 4,102. Basically, is there an vba function for excel that
converts a number to a string and then adds the comma separator for
thousands? If not what code would I use to do this?


Thanks.

 

[Bob Phillips]

rentsTxtBox.Value = Format(rents,"#,##0")

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[prahz]

Thank you!

rentsTxtBox.Value = Format(rents,"#,##0")

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)