Userform- Formating numbers in Textboxes
 

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

Userform- Formating numbers in Textboxes
 

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)

"Ozgur Pars" wrote in message
...
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

Userform- Formating numbers in Textboxes
 

Hi Ozgur,

Try:

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


---
Regards,
Norman



"Ozgur Pars" wrote in message
...
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

Userform- Formating numbers in Textboxes
 

Hi Ozgar,

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


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


---
Regards,
Norman

Userform- Formating numbers in Textboxes
 

Bob , Norman,
thanks alot for your help.

Ozgur

"Bob Phillips" wrote:

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)

"Ozgur Pars" wrote in message
...
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