Private Sub TextBox1_Change()
If Val(TextBox1) > 8 Then TextBox1 = Left(TextBox1, Len(TextBox1) - 1)
End Sub
Private Sub TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
If InStr(1, "0123456789,", Chr(KeyAscii)) = 0 Then KeyAscii = 0
End Sub