View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rick_Stanich[_8_] Rick_Stanich[_8_] is offline
external usenet poster
 
Posts: 1
Default validation of textbox entries


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