Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reference a list to perform a function in Excel | Excel Worksheet Functions | |||
How do I reference an Excel filtered list in a function? | Excel Worksheet Functions | |||
Cell reference in the auto filter custom list | Excel Discussion (Misc queries) | |||
cell reference to last item in a list | Excel Discussion (Misc queries) | |||
Place a set value in a cell from a drop down list name reference | Excel Worksheet Functions |