I'd start with Debra Dalgleish's site:
http://contextures.com/xlDataVal02.html

Richard Edwards wrote:

Am i able to determine the values shown in either a validation list or combo
box being dependant on a value in another cell?

ie: Cell A1 = BOB then validation or combo box would then base it's list
from the named range (or whatever the solution may be) based on Bob.
if i was to change A1 to ROY then it would also change the underlying list?

I have tried everything that i think SHOULD work but that it pretty
limited...

thanks in advance

rich

--

Dave Peterson