I would like to have my drop down box in excel read D1a - cleaning, but when
I click on it, only D1a appears in the cell. Is there any way of
accomplishing this task. I am a novice to excel and have never used VBA so I
may need a detailed explantation.