Drop down list

[charityb]

I am trying to create a drop down list for a form that I was successful in doing, however, when I erase the choices I had input into the cells to create the drop down list, the choices in my list also disappear. I want the drop down list but an empty form to start with. Any help out there??




SOLVED

[FDibbins]

Hi and welcome to the forum

To automatically clear the DD cell will need VBA. Alternatively, you could have a blank cell at the start of your list and then select that to have the DD show blank