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.
Code:
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?