Format Textbox on UserForm as Currency

Hi,

I am creating a pricing userform which takes a value from 'Sheet1'!A1 and that cell is formatted as currency. On UserForm1, I have dropped in a textbox with a ControlSource of 'Sheet1'!A1. I would like the value to be formatted as currency when it appears in the the userform textbox as it is in the cell on the worksheet. For some reason, there is no way of doing this in the properties window.

Thanks for help.

Paul, Southampton

Hello paulsouthampton,

Here is how to do it.

Amount = TextBox1.Text
TextBox1.Text = Format(Amount, "Currency")

Easy when you know how.
- Leith Ross

Leith,

That's great! Thank you very much.

Paul, Southampton, UK

Originally Posted by Leith Ross

Hello paulsouthampton,

Here is how to do it.

Amount = TextBox1.Text
TextBox1.Text = Format(Amount, "Currency")

Easy when you know how.
- Leith Ross

I have a formatting issue as well but can't seem to get it resolved. seehttp://www.excelforum.com/excel-prog...urrency-2.html I tried your "Amount=" above but am not sure if it didn't work because I do not know what event to code with that?