how do i format a textbox on a userform created in excel

  • Thread starter Thread starter Bert
  • Start date Start date
B

Bert

I created a userform to accept information from the user.
My problem is ,eg i would like the TxtAmount.value to display the amount in
Currency when i enter the number. The same for the percentage control.

I am new to this.
 
Bert,

Text boxes accept text only, so you need to convert the value to the
formatted text that you want.

Something like:

UserForm1.TextBox1.Text = Format(Range("A1").Value, "$#,##0.00")

Same idea for percentages"

UserForm1.TextBox1.Text = Format(Range("A1").Value, "0.00%")

HTH,
Bernie
MS Excel MVP
 
Back
Top