Can I get some help on expanding this code? Even direction will be
useful as I don't mind learning by reading oe examples (Yes, I have
searched for many hours).
(snippet)
If Not (IsNumeric(TextBox1.Value)) Then
MsgBox "Entry must be numeric"
Exit Sub
End If
I have a userform with 2 to 100 textbox's to itterate thru for a
numeric condition to be true less one text box which will be a Date.
Can this be coded to check all textbox's less one (call it textbox1)
with out specifying every textbox?
In the above code TextBox1.Value will have to be a variable.
--
Rick_Stanich
I am me
------------------------------------------------------------------------
Rick_Stanich's Profile:
http://www.excelforum.com/member.php...o&userid=28957
View this thread:
http://www.excelforum.com/showthread...hreadid=511369