Urgently help needed - dropdown box does not show up
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. |
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. |
All times are GMT +1. The time now is 11:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com