Function to use a list box or reference a cell

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

Is there a way to utilize a list box if there is nothing in another cell and
if there is something in the other cell then not display the list box?
 
I have resolved the problem although the list box is still available.

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.
 
Back
Top