Textbox1.Text = Format(myval,"$ #,##0.00")

--
Regards,
Tom Ogilvy

"jes" wrote in message
...
Hello,

I'm trying to declare a currency variable in excel. Do
you know how to keep the file size low and format a
textbox to currency?

Thank you