Need Help on Number format on textbox in userform exel

[spycein]

Hi Everyone,

I need your help on number formatting in excel vba userform.

I am using a userform to retrieve data from my excel sheet to my userform.

My userform consists of multiple textboxes. i want to format these textboxes as number and the appearance of the data in the texbox would be in the following format, "0,00,00,000.00"

On my excel sheet the data format is exactly the same which i have mentioned above, but when i run the macro to retrieve the data on my userform it shows as "00000000".

Please help me on this.

Thank you so much in advance.

Regards

Shib

 

[ParamRay]

If the textbox gets its value from a worksheet cell, the cell's Text property will give a string representation of the cell's value according to its number format:

UserForm1.TextBox1.Value = Sheet1.Range("A1").Text

 

[spycein]

Hi gpeacock,

It does not work.