=IF(Q5="Apple Sauce",List1," ") - #Value Error ???

So have been struggling on this one for a bit. The issue comes up with the "List" element.

Current Q5 is a list that works fine. Of the options there "Apple Sauce" is one of them. If Q5 isn't apple sauce, this targeted cell remains clear (which I want).

The issue is when it IS Apple Sauce its not creating the drop-down list I want.

Verging on head-banging-desk. Can anyone help me avoid a self-concussion? :P

Hi, an IF statement can't create a drop down list (As far as I am aware). It just returns a single item.

Well.... can you offer me an alternative to produce the effect I'm attempting to achieve? I kinda already know that this isn't working

The code below works for me (Office 2003)

1. The code assumes you have 'Named' your range of cells with your list items in as 'MyList'
2. The code is placed in the required sheet in VBA under 'Microsoft Excel Objects'

Please Login or Register  to view this content.