Function to use a list box or reference a cell
 

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?
--
Dan

Function to use a list box or reference a cell
 

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.


--
Dan


"Dan" wrote:

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?
--
Dan