How to control if a cell references versus list box or another cel

[Dan]

I have created a validation list box where I can choose to make a selection
from the list box. However in some instances I would like to make the cell
reference another cell in another worksheet using the = command if that other
cell contains specific information, otherwise I would like it to show the
list box function.

Presently I have to do one or the other. Is there a way to do this?

 

[Dan]

I have resolved the problem. If you first create a list box and then copy
the box to a location in say worksheet2, cell E4. The list box will function
as expected. Then if in the same cell you enter an IF statement such as "
=IF(Legend!D3="","",Legend!D3) " to reference the Legend worksheet, then if
there is nothing in D3, the dropdown list will still be available, if there
is something in Legend!D3 then the cell will show the contents of Legend!D3.

The only issue with this is that if there is a valid entry in Legend!D3 and
it does show up in worksheet2, cell E4, then the user could still use the
list box to change
the contents.

Dan