Private Sub TextBox15_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
With TextBox15
x = Trim(Replace(.Value, " €", ""))
Select Case KeyCode
Case 96 To 105
If Right(x, 3) Like ",*" Then KeyCode = 0
x = x & Chr(KeyCode + IIf(KeyCode < 96, 32, -48))
Case 110, 188: If Not x Like "*,*" Then x = x & ","
Case 8: x = Left(x, Len(x) - IIf(x <> "", 1, 0))
Case 46: x = Left(x, .SelStart)
Case Else: KeyCode = 0
End Select
x = IIf(Not x Like "*,*", Format(x, Right("### ### ### ### ### ### ### ###", Len(x))), x)
.Value = x
If .Value <> "" Then .Value = .Value & " €"
.SelStart = Len(x)
End With
KeyCode = 0
End Sub