ExcelBanter - Userform textbox number formats

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Userform textbox number formats (https://www.excelbanter.com/excel-discussion-misc-queries/92578-userform-textbox-number-formats.html)

PhilM

Userform textbox number formats

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

Userform textbox number formats

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?

PhilM

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

All times are GMT +1. The time now is 05:04 PM.