Never underestimate the amount of work that has already been done in
Excel!!!

Check out 'Excel -- Data Validation -- Hide Previous Selections'
(http://www.contextures.com/xlDataVal03.html)

for a way to do what you want with Data Validation - looks a LOT
simpler than anything I suggested!


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109671