View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
scantor145[_23_] scantor145[_23_] is offline
external usenet poster
 
Posts: 1
Default Mutually exclusive values


Excel 2003
Visual Basic 6.3

I have a form with 24 text boxes. The names of the text boxes all
start with “txt”, e.g. txtCHOL, txtALB, etc. The values that are
entered into the text boxes can range from 1 to 24. Is there an easy
way (VB code) to check that each box has a different number, that is,
mutually exclusive.

Thanks


--
scantor145
------------------------------------------------------------------------
scantor145's Profile: http://www.excelforum.com/member.php...o&userid=14766
View this thread: http://www.excelforum.com/showthread...hreadid=528559