Function to use a list box or reference a cell

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

Dan

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
Using the list form control: multi-selection possible? 3
How to make repeating drop-down lists? 2
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Excel - Wich Function should I use? 1
list or combo box 0
Is there a function to count how many times a cells value is used? 0
Custom reference in Word 2016 2

Top