Data Validation

[Mkammari]

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?

 

[Brian from Maui]

Are you able to use Data Validation from the Data menu instead of VBA?

 

[Mkammari]

Trying to validate a text box on a userform. Don't have a a data menu.

 

[daniels012]

In the menu Bar!

File, Edit, View, Insert, Format, Tools, Data

Michael

 

[Mkammari]

I have it in an excel worksheet, but I do not have that menu option in VBA. I am validating user input on a userform, not in an excel worksheet.

 

[Oaktree]

Untested, but could you do:

If (Not IsNumeric(txtqty15.Value)) and len(txtqty15.value)>0 Then

?

 

[Mkammari]

it works oak....appreciate it