interesting...because this is not how drop down lists work.....
question: when you created the list, did you hard code the values or are you
referencing the values in some range in your workbook?

"Davida" wrote:

I created a drop down list in excel, however it only allows me to choose each
item only once and then it's gone from the list. I need to be able to choose
each item multiple times.