Private Sub TextBox1_Change()
Dim t$, i, x$
t = TextBox1
For i = 1 To Len(t)
If IsNumeric(Mid(t, i, 1)) Then x = x & Mid(t, i, 1)
Next
x = Left(x, 14)
i = 1
While Mid(x, i, 1) <> ""
If i = 3 Then x = Left(x, 3) & " " & Mid(x, 4): i = i + 1
If i = 7 Then x = Left(x, 7) & " " & Mid(x, 8): i = i + 1
If i = 11 Then x = Left(x, 11) & " " & Mid(x, 12): i = i + 1
i = i + 1
Wend
TextBox1 = x
End Sub
Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
If Len(TextBox1) < 17 Then Cancel = True
End Sub