Change format of userform textbox to currency

[jeff2813]

Hi there, I have a userform with 4 textboxes that when text is entered they all refer back to individual cells. All data entered on a spreadsheet goes to the userform and when entered into the userform goes back to the spreadsheet. One of the textboxes displays a price but i cant seem to change the format to a currency from numerical. is there a way to change the format like a excel cell or do i need a specific code to achieve this? Thank you

 

[Fluff]

Maybe something like

Me.TextBox1.Value = "123.45"
Me.TextBox1.Value = Format(Me.TextBox1.Value, "[COLOR=#ff0000]£#,##0.00[/COLOR]")

change part in red to suit

 

[jeff2813]

Well thank you for your time but i cant seem to get it to work. Probably just me as im pretty new at this.

 

[Fluff]

Are you entering data into the textbox, or just pulling data from the sheet?

 

[jeff2813]

As an example. When i press a1 and that cell has 25$ in it as currency, a userform pops up with 25 in it but it has no currency ex $25.00. I can also press $30 in the userform textbox but when goes back to A1 it comes back as a correction that tells me its text and would i like to put it in a a number. They need a built in currency box as well as textbox, life would be easier.

 

[Fluff]

Can you post the code that you are using?