see if this link gets you what you need

http://www.contextures.com/xlDataVal02.html



"loren" wrote:

This is the scenario - I have a number of domains each with their own unique
set of capabilities - does anyone know how I can represent this using a
drop-down function so that for example when I select domain1 I am only
allowed to enter the domain1 capabilities