Number Format for Txt and Lbl

[Jug]

Hello,

Was hoping I could get some help on this...

I created a userform in excel's vb environment. On the form I have two text boxes, a label and a command button. It is basically a calculator.

The user inputs numbers into the two text boxes, hits the command button which then inputs the result into the label caption.

"label1.caption = text1.value * text2.value"

My question is... how do you format the text boxes and label so that the numbers uses commas so it looks like "1,000,000" instead of "1000000" when the user inputs them and also when it calculates.

Thanks a bunch.

-Jug

 

[Excelenator]

Use

label1.caption = worksheetfunction.text(text1.value * text2.value,"_(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)")

 

[Jug]

marry me.

thanks a BUNCH!!!

 

[Oaktree]

Or,

label1.caption = format(text1.value * text2.value,"#,##0")

 

[Jug]

even better! thank you!!