Data Validation: What Am I Doing Wrong
Posted by Dwight on November 05, 2001 5:10 AM
Want to create a drop down list using data validation. Worksheet is unprotecyed; I didn't create it but unaware of any special formatting. In the target cell I choose: "Data, Validation, Settings, Allow: List, and type in three entries for the drop down in the "Source" box, separated by commas (tried with & without space in addition to the commas) as in: "Audited, Compiled, Tax Return". Left the "in-cell dropdown" and "ignore blank" boxes checked. Clicked "OK" to complete the process.
After this exercise, when I click on the cell there is no dropdown list. When I select the selct and again choose "Data, Validation" the information I entered previously is there.
Anybody know what I'm doing wrong?
Posted by Aladin Akyurek on November 05, 2001 7:34 AM
Dwight,
Add a worksheet to the workbook, rename it as Admin, put Audited, Compiled, and Tax Return in say column A from A2 on. Select A2:A4, go the Name Box on the Formula Bar, type a name e.g., AuditList.
Delete the row (or the cell) where you want your drop-down list. Activate the cell of interest in the row.
Activate Data|Validation.
Select "List" for Allow.
Enter as Source:
=AuditList
Click OK.
See whether this proc works. If not, I'm interested in having a look at that workbook.
Cheers.
Aladin
=============
Posted by Aladin Akyurek on November 07, 2001 3:18 PM
With Freeze Panes activated, Dwight's drop-down lists just above "freeze" line become unavailable, while there. Unfreezing makes them fully available.
This must be a bug.
Aladin
============
