Re: Formating string as "#,###.00"

Jim,

Your original post was a bit confusing as you said

... Where str6 = "22(vbcr)33.18(vbcr)-125(vbcr)1191.56"

and then said

... Which shows up (in Userform) as: 22 ...

so I assumed there was some string manipulation going on to extract 22 from
str6. If you pass that original str6 value to the textbox, of course it
won't get formatted, it is not a number.

Can you clarify a bit?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"JMay" <jmay@xxxxxxx> wrote in message
news:k5Yyh.15804$5q6.11273@xxxxxxxxxxxxxxx
Now with:

UserForm1.TextBox1.Text = Format(str6, "#,##0.00;(#,##0.00)")
UserForm1.Show vbModeless

I'm seeing "No Change" from before. hummm
(No part is affected, from beginning to end of string)

Jim

"Bob Phillips" <bob.NGs@xxxxxxxxxxxxx> wrote in message
news:uqHyDEDTHHA.996@xxxxxxxxxxxxxxxxxxxx:

UserForm1.TextBox1.Text = Format(str6,"#,##0.00;(#,##0.00)")
UserForm1.Show vbModeless

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"JMay" <jmay@xxxxxxx> wrote in message
news:iyXyh.15767$5q6.8749@xxxxxxxxxxxxxxx
Presently in my code I have:

UserForm1.TextBox1.Text = str6
UserForm1.Show vbModeless

Where str6 = "22(vbcr)33.18(vbcr)-125(vbcr)1191.56"

Which shows up (in Userform) as:

22
33.18
-125
1191.56

What can I further do to format somewhere(?) to get (in the userform)
as:

22.00
33.18
(125.00)
1,191.56

??

Thanks in advance..





.

Loading