Hi all,

I'm trying to create an Excel program with drop down lists that can be easily customised by each user (and assuming no or very basic Excel knowledge on the part of each user). At the moment I have placed tick boxes via form control next to each of the possible options to include in the drop down lists. I've then linked each check box to a cell to get a TRUE/FALSE result and then used an IF statement to either display the option or a blank depending on whether or not the box is ticked (e.g. IF(A7,A1,"").

The problem is that when I go to make a drop down list in data validation Excel doesn't treat these cells as blanks so I get a drop down list with big spaces in it - does anyone know how I can resolve this issue?

Thanks in advance,

Laura