The if statements worked well and I put it in the change event. Now it
works great. Thank you both.

Todd

"Todd Huttenstine" wrote in message
...
Hey guys,

I still cannot get a $ sign to come up before everything I type in a
textbox.


I want to be able to type in lets say TextBox1 and when I do, the $ sign
pops up in front of the number. I need the dollar sign to always be there
no matter how many times I re-enter numbers and I need it to format the
cell
as $0.00