If Then Statement
 

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

If Then Statement
 

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

If Then Statement
 

Thanks Jim.

I noticed the drop downs in the example only allow the user to select one
item from the drop down list.

Is there anyway to allow the user to select multiple items from the primary
and secondary drop down list?

I am not familiar with Visual Basic and haven't a clue where to even begin.

Thanks,
Jodie

"Jim Thomlinson" wrote:

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