View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
PhilM
 
Posts: n/a
Default Userform textbox number formats


Harald Staff wrote:
Hi

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

HTH. Best wishes Harald

"PhilM" skrev i melding
oups.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