ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Data Validation List (Drop Down) Not Showing (https://www.excelbanter.com/excel-discussion-misc-queries/253166-data-validation-list-drop-down-not-showing.html)

Dave

Data Validation List (Drop Down) Not Showing
 
I have a validation with drop down list in it but the drop down is not
showing. I can go into the cells with the validation and it shows that it is
set up to be a validation with list. The source of the list is correct. The
drop down worked at one point but now it doesn't. Did I format the cells in
a way that does not allow for validations with lists?

Any help is appreciated. I have been fighting with this off and on all day.
Thanks

Homey

Data Validation List (Drop Down) Not Showing
 
check you have option to show objects turned on. in excel 2003 it in View
section of excel options.


"Dave" wrote in message
...
|I have a validation with drop down list in it but the drop down is not
| showing. I can go into the cells with the validation and it shows that it
is
| set up to be a validation with list. The source of the list is correct.
The
| drop down worked at one point but now it doesn't. Did I format the cells
in
| a way that does not allow for validations with lists?
|
| Any help is appreciated. I have been fighting with this off and on all
day.
| Thanks


zvkmpw

Data Validation List (Drop Down) Not Showing
 
check you have option to show objects turned on. in excel 2003 it in View
section of excel options.


I have the same problem with a particular workbook, but not with
others. It's Excel 2003.

For ViewObjects, "show all" is selected.

Under DataValidation, "In-cell drop-down" is selected.

Anything else that should be examined to bypass the problem?


All times are GMT +1. The time now is 11:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com