Debra Dalgleish;169381 Wrote:
There are instructions here for hiding used items in a data validation
list:

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

No, that page shows usage of Dependent Lists, lists that completely
change to other lists based on prior choices...sequential List Boxes, if
you will.

The workbook I posted shows a way to ACTUALLY cause individual items to
drop out of the Validation List. I'm still looking for a way to cause a
validation list to skip the blank spots my technique creates in the
list.


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=46886