Check out this link...

http://www.xldynamic.com/source/xld.Dropdowns.html
--
HTH...

Jim Thomlinson


"Jodie" wrote:

I have a worksheet where column 7 & 8 are populated by the user selecting an
item from a drop down box. Both columns have code allowing the user to
select multiple items from the drop down box.

Is there anyway (ontop of the current coding) to only show certain items in
column 8 when a specific item is selected in column 7?

For instance if the user selected "Residual" in column 7 we only want "Push
to clear IDCs" and "No action to take - all IDCs empty" to be available
for selection in the drop down list in column 8.

Is this possible?

Thanks,
Jodie