Userform textbox number formats

[PhilM]

Hi

I need to set the number format of a textbox (in a userform) to show a
percentage. How do go about this?

[Harald Staff]

Hi

Dim D As Double
D = 418 / 1300
TextBox1.Text = Format$(D, "0.0%")

HTH. Best wishes Harald

"PhilM" <philip.martin@northumberlandcaretrust.nhs.uk> skrev i melding
news:1149673979.435118.324370@c74g2000cwc.googlegroups.com...
> Hi
>
> I need to set the number format of a textbox (in a userform) to show a
> percentage. How do go about this?
>

[PhilM]

Harald Staff wrote:
> Hi
>
> Dim D As Double
> D = 418 / 1300
> TextBox1.Text = Format$(D, "0.0%")
>
> HTH. Best wishes Harald
>
> "PhilM" <philip.martin@northumberlandcaretrust.nhs.uk> skrev i melding
> news:1149673979.435118.324370@c74g2000cwc.googlegroups.com...
> > Hi
> >
> > I need to set the number format of a textbox (in a userform) to show a
> > percentage. How do go about this?
> >

Spot on, thanks Harals