How do I set the numberformat of a textbox- VBA/VB6

[Ankoump]

Dear All,

I have the following code which populates a textbox with a value from an excel cell, in this case 2000000. But I want the commas and cannot seem to get them even though the excel cell has the format 2,000,000.


Please can anyone tell me how to make sure the textbox value has the commas.

Thanks in advance!

[Sabin_33]

You can change the DAtaFormat properties.


Or you can Format the data going into the textbox
textbox1.text = FORMAT(Number, "###,###,###.00")

[Comintern]

You just need to format the value you get from Excel. Excel stores everything as variants, so if there is a number in the cell, it gets a numeric sub-type.

Text1.Text = Format$(Value, "#,###")

[Ankoump]

Many thanks guys...it worked a treat!