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

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..
>
>

.

Relevant Pages

  • Re: Formating string as "#,###.00"
    ... "Bob Phillips" wrote: ... Dim i As Long, iStart As Long, iEnd As Long ... Dim str1 As String ... UserForm1.Show vbModeless ...
    (microsoft.public.excel.programming)
  • Re: multiple user formshow
    ... You missed the "vbModeless" after Show ... > Private Sub CommandButton3_Click ... >> HTH ... >> Bob Phillips ...
    (microsoft.public.excel.programming)
  • Figured it out!
    ... "Tom Ogilvy" wrote: ... but don't know what the role of userform is or specifically what is ... user.show vbModeless ... drawing entities in AutoCAD based upon data in the Excel cells. ...
    (microsoft.public.excel.programming)
  • Re: Using Cells while UserForm shown
    ... but don't know what the role of userform is or specifically what is ... user.show vbModeless ... drawing entities in AutoCAD based upon data in the Excel cells. ... controls on them. ...
    (microsoft.public.excel.programming)
  • Modeless UserForm
    ... I have an excel application that ... basically creates a series of multi-pages on a userform based on a directory ... On the multi-pages are buttons for each ... VBA.UserForms.Add.Show vbModeless ...
    (microsoft.public.excel.programming)
Loading