MrExcel Publishing
Your One Stop for Excel Tips & Solutions

I am sure this has been asked but I have basic UserForms question

Posted by J.D. Cronin on November 28, 2000 11:20 AM

I have developed a basic UserForm with TextBoxes.

The problem I am having is that I wish to format textboxes when I either input values into them or read values into these TextBoxes.

For example in one TextBox on the UserForm I may want to enter $100,000,000 but all I can figure out so far is to enter 100000000 -which as you can imagine is terribly hard to read. Any suggestions would be most welcome

Thanks very much!

Posted by Kristen on November 28, 2000 11:37 AM

Click on Format-->Cells and choose currancy and select where /if you want the decimal point to be
Hope this helps ya out~

Posted by J.D. Cronin on November 28, 2000 11:50 AM

Thanks Kristen but your solution is geared towards

cells in the spreadsheet..I am asking about TextBoxes in a UserForm..unless there is something I am missing?


Posted by greg on November 28, 2000 7:30 PM


Private Sub TextBox1_AfterUpdate()
TextBox1 = Format(TextBox1, "$#,##0.00")
End Sub

That should work for you.

Posted by J.D. Cronin on November 29, 2000 5:55 AM

Greg: Thanks Very M uch..You 'da Man!*