Transfer percentage into UserForm

[KA_Analyst]

Yet again with this coding! Sorry.

My spreadsheet has percentages in but doesn't transfer into the UserForm - it transfers as 0.25 instead of 25%.

Is there a way I can have the UserForm showing 25% rather than the decimal format?

Please Login or Register  to view this content.

[FrankBoston]

"23.3%" = Format(.233, "0.0%")

[KA_Analyst]

Sorry - being really dumb here, I have not a lot of knowledge of VBA, where do I format it?

[davesexcel]

Private Sub UserForm_Initialize()
TextBox1.Value = Format(Range("I1"), "0.0%")

End Sub
This populates the textbox when you open the userform