I created a drop down list box and it worked fine this morning.
Now when I open the file and move over the cell, the drop-down is gone.
However, I must enter the correct value before it accept the entry.
Please help to bring back the drop down list.
(Maybe I set some thing wrong?)
Thanks.

Is your drop down list done by Data Validation? If you did, make sure you
have selected "In-cell dropdown" when you created the data validation list.
Then save your workbook.

Tyro

"bau" wrote in message
...
I created a drop down list box and it worked fine this morning.
Now when I open the file and move over the cell, the drop-down is gone.
However, I must enter the correct value before it accept the entry.
Please help to bring back the drop down list.
(Maybe I set some thing wrong?)
Thanks.

Yes, I created by Data Validation and have he in-cell dropdown box checked.
It worked this morning, but now it disappeared.
Thanks,

"Tyro" wrote:

Is your drop down list done by Data Validation? If you did, make sure you
have selected "In-cell dropdown" when you created the data validation list.
Then save your workbook.

Tyro

"bau" wrote in message
...
I created a drop down list box and it worked fine this morning.
Now when I open the file and move over the cell, the drop-down is gone.
However, I must enter the correct value before it accept the entry.
Please help to bring back the drop down list.
(Maybe I set some thing wrong?)
Thanks.