Conditional Validation Using List Control

[morton20]

Hello,

I want to use a multi-select list control but I want that list control's values to vary based on the input of another cell (the normal way to do this would be to create two named ranges and then use INDIRECT to control which named range is loaded as the validation: http://www.mrexcel.com/forum/showthread.php?t=578390&highlight=dependent+validation). However, when I attempt to input the INDIRECT formula into the Form Control Control Tab, it won't recognize my attempts. Is there any workaround for this problem?

Thanks!