I am trying to force the a user to enter only numeric entries, however the entry can be left blank as well. So far this is what I have.
Private Sub txtqty15_exit(ByVal cancel As MSForms.ReturnBoolean) If Not IsNumeric(txtqty15.Value) Then MsgBox "You must enter a numeric value for the qty field" With txtqty15 .SetFocus .SelStart = 0 .SelLength = 1000 End With End If End Sub yet...when the entry is left blank, I don't want the message to pop up. I would like to accept null values as well as only numeric. Anyone?