Dollars in a text box

J

Jeff

I have a text box, and I want the user to enter a dollar
value. How do I force the entry to a currency, and how do
I display it as $123.45 ??

Thanks in advance...
 
J

Jeff

But this is a text box in a VBA form - not a cell on the
worksheet. Formatting the column doesn't work on a form
(unless I'm missing something in your reply...)

Thanks - Jeff
 
T

Tom Ogilvy

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
if isnumeric(Textbox1.Value) then
Textbox1.Value = Format(Textbox1.Value,"$ #,##0.00")
End if
End Sub
 
Top