How do you format a TextBox on a UserForm as Currency

I have a CommandButton on a sheet that will copy a dollar value in C15 and place it in a TextBox (txtPrice1) on a UserForm. The value in C15 is, for example, $7,000.00. When it is displayed on the UserForm, it is simply 7000. I want the TextBox to display $7,000.00 also. I would like a way to just permanently format the TextBox as currency (or accounting), as opposed to carrying over the format from C15, if possible. Hopefully someone can show me a simple way to do this. I'm pretty much a novice, if I need to add code, can you tell where to put it. An example of my workbook is attached. Thanks in advance.

Hi rkjudy

Perhaps like this

Please Login or Register  to view this content.

Far as I know, a TextBox is just that...text...can't be "permanently" formated otherwise.

John

Please Login or Register  to view this content.

Hi rkjudy

In your sample file txtPrice1 is getting populated with this

Please Login or Register  to view this content.

in the Initialize Event. How are txtPrice2, txtPrice3.....txtPrice15 getting populated and where are they on your UserForm? Don't see them there.

Please Login or Register  to view this content.