Formatting a VBA Form as Currency

This has to be VBA 101... but....

can I format a textbox in a VBA form that when I input 500 and go to the next box, it formats it as a currency and displays "$500.00"

i'm sure it's super easy, i just don't know the steps.

ok, here it is, i was thinking it would be much easier, but i can't seem to get it.

there are 6 categories that i need to format as a currency, they are:


Assigned Fee
Billing Rate
Tax Strategies Fee
Transactional Tax Fee
Business Valuation Fee
Website Fee

here's the workbook, i'm pretty lost.

I just learned that you can use format names in a Format function -- my Excel lesson for the day, thanks, Roy.

You could generalize Roy's approach a tad:

Please Login or Register  to view this content.