Hi,

I have no knowledge of VBA and macro but I use excel a lot for work.

My question is if someone can help me by explaining exactly how to do this..

Basically, I have a drop down list with different options. By IF functions I have made a list of questions that appear depending och which option is selected in the drop down list. I want this list of questions to have check boxes that I can tick and depending on if they are ticked or not they appear somewhere else. So far so good.

My problem is that when the drop down list shows nothing I don't want the checkboxes to be visible. I only want to be able to see the checkboxes when questions appear and I have understood that this is only possible when using VBA and macro (that I know absolutely nothing of). One solution could be to hide/show a column which contains the check boxes but the check boxes do not follow the columns and they appear even though columns are hidden.

Would really appreciate some help!

Thanks a lot!