sharky12345
Well-known Member
- Joined
- Aug 5, 2010
- Messages
- 3,404
- Office Version
- 2016
- Platform
- Windows
I'm trying to automatically format a textbox on a userform so that it displays currency but can't get it to do what I want.
As an example, if the user enters 12345 then I want the Textbox to display "£123.45". If they entered 1234 then I want the Textbox to display "£12.34".
I've got this so far but it's producing "£12,345":
Can someone assist?
As an example, if the user enters 12345 then I want the Textbox to display "£123.45". If they entered 1234 then I want the Textbox to display "£12.34".
I've got this so far but it's producing "£12,345":
VBA Code:
If IsNumeric(TextBox1) Then
TextBox1 = FormatCurrency(TextBox1, "0.00")
End If
Can someone assist?