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

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.
 
B

Bernie Deitrick

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set focus (and select text) on a text box on a modeless userform? 0
Excel does not accept text format! 0
Mail Merge - displaying a conditional number of decimals 5
Create a dynamic list on a userform outside of a list control 0
display special characters in some textbox fields to ensure data f 1
Date Format for Userform TextBox 4
pass to textbox on a form and to excel worksheet 0
working with textboxes-VBA 0

Top