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.

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,

"bau" wrote:

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.