Select the cell, do datavalidation and re-select in cell dropdown, pick
from dropdown list is something else


--
Regards,

Peo Sjoblom



"Lisa" wrote in message
...
I set up a validation (drop down box) on the same tab. The dropdown box was
working fine until now. I have checked that excel is on automatic. If I
look
at the validation (it's there). However, if I click on the cell I do not
get
the right arrow showing there is a dropdown box. I can right click and
choose
"pick from drop down list"; however, my the list is not the same. I have
deleted and reenterred it. I have tons of data in the workbook so before I
start over, I wanted to see if anyone has had this problem.

Very confused,
Lisa