ActiveX Input Format as currency with 2dp

[JonReyno]

Hi All,

I have been trawling the web and Mr Excel for an answer, but everything I have tried doesn't work. I am creating a userform that users need to be able to add in monetary values. Below is how I have the textbox set up at the moment, but it's not doing what I want:

Private Sub TextBox18_Change()
    TextBox18.Value = Format(TextBox18.Value, "###,##")
End Sub

If I wanted to enter the value 1,234.56 into the cell I can't. It will give me 1,234 but doesn't all the .56. So I have tried different variations on it, commonly "###,##0.00" but that keep giving me 1.00 as a result.

Does anyone have a stroke of genius that will help me out? I don't mind if the filed has £ at the front or not. Currently I have that outside the box, but it can be part of the solution if needs be.

 

[JonReyno]

That's OK, I appreciate your help. I have just muddled something together and didn't really think about making it into a proper form. Lessons learnt for next time. If there isn't a way to change it, then it'll have to stay as it is. I've put too much work in to unpick it now.