drop-down listbox disappeared

B

bau

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.
 
T

Tyro

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
 
B

bau

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validation - Force entry from drop down list 1
Filtered drop down list 2
drop-down menu disappeared 6
Formatting a drop down list 2
Excel Formatting in Drop Down Lists 2
Drop Down Lists 1
Change drop down list in one cell based on values in other cells 2
drop down list 2

Top