Urgently help needed - dropdown box does not show up

B

bau

Please help:
In one of my worksheets, the dropdown box does not show while it is OK in
others.
Please help...

In both cases (non working worksheet vs. working worksheet) I do the
followings:
Creating new dropdown box by choosing "data">"validation"

In "Settings" tab:

Allow:(list) & Source: (test)
With both Ignore blank and in-cell dropdown radie buttons selected

In "Input Message" tab:

Title: (none); Input message (none)
With "Show input message when cell is selected" button selected

In "Error Alert" tab:
Style:(Stop); Title:(none); Error message:(none)
With "Show error alert after invalid data is entered" button selected.

Thanks.
 
B

bau

What I did to solve the problem was to copy the entire worksheet and paste it
to the new one, then deleted the not working one and renamed the new one same
as the deleted one.

May be Exel got some bug?

Anyway, it works now.
Thanks all.
Regards,
 

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

Top