Textbox to Display Currency

Please Login or Register  to view this content.

this is the code i am trying to use but the format does not show up if I change the private sub txttarget_format() to private sub txttarget_change the format works but because it is a change it will only let me enter the first digit and not all four digits that i want to enter.

Hi James. Be sure to read through the Forum Rules so you can use and follow them effectively. For instance, you'll need to edit that post above and put code tags around that code you used. (Like I did below...)

The _change event triggers ANYTIME there is a change, in a textbox it is trying to trigger with every digit you type. You need to arrange the macro so that it first checks if you're done typing. You said 4 digits, so if it's always 4 digits, then something like:

Please Login or Register  to view this content.

Hello James12,

You can place the code in the TextBox_AfterUpdate() event of the UserForm. This formats the entry, provided of course numbers were entered, as currency.

Please Login or Register  to view this content.