Urgently help needed - dropdown box does not show up
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.
|