Data Validation

Mkammari

Board Regular
Joined
Nov 23, 2005
Messages
65
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?
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

daniels012

Well-known Member
Joined
Jan 13, 2005
Messages
5,219
In the menu Bar!

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

Michael
 

Mkammari

Board Regular
Joined
Nov 23, 2005
Messages
65

ADVERTISEMENT

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

MrExcel MVP
Joined
Jun 20, 2002
Messages
8,052
Office Version
  1. 365
Untested, but could you do:

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

?
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,501
Messages
5,832,088
Members
430,110
Latest member
Chyke_mxl

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top