Userform- Formating numbers in Textboxes

[Guest]

Hello,
I am trying to find a way to format the numbers in a textbox which derives
the data from a excel sheet. Nothing too fancy but I can't figure it
out...any help?

Thanks,
Ozgur

 

[Bob Phillips]

Textbox1.Text = Format(Range("A1").Value,"$#,##0.00")

for example.

If the range is already formatted you could use

Textbox1.Text = Range("A1").Text

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Norman Jones]

Hi Ozgur,

Try:

With TextBox1
. Text = Format(.Text, "##,##0.00")
End With

 

[Norman Jones]

Hi Ozgar,

With TextBox1
. Text = Format(.Text, "##,##0.00")
End With

Better, as Bob shows, to format the input data directly.

 

[Guest]

Bob , Norman,
thanks alot for your help.

Ozgur

Textbox1.Text = Format(Range("A1").Value,"$#,##0.00")

for example.

If the range is already formatted you could use

Textbox1.Text = Range("A1").Text

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)