Rlb53
03-14-2012, 07:40 PM
Hello All.
As Always... I have a Textbox in a Userform.
I need to confirm that a Numeric Value is placed into this Textbox before the Code Continues. If an alpha value is inserted into the textbox it throws an error code because it is directly attached to a Numeric Formula.
If possible... I'd like to use a simple "If, Then" statement.
Can you help me correct the syntax please?
If IsText(Qty.Value) Then
MsgBox " You must enter a Valid Quantity"
Qty.SetFocus
Qty.Value = ""
Exit Sub
End If
Thank you Once Again !
As Always... I have a Textbox in a Userform.
I need to confirm that a Numeric Value is placed into this Textbox before the Code Continues. If an alpha value is inserted into the textbox it throws an error code because it is directly attached to a Numeric Formula.
If possible... I'd like to use a simple "If, Then" statement.
Can you help me correct the syntax please?
If IsText(Qty.Value) Then
MsgBox " You must enter a Valid Quantity"
Qty.SetFocus
Qty.Value = ""
Exit Sub
End If
Thank you Once Again !