| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation and Forms
Is there anyway to get a Data Validation List in cells to show up in the Data
Form? I have several columns with Data - Validation - List (and lists I created) on the spreadsheet, but when you go to Data - Form, you just get the normal blank cell to enter data into and their is no List. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Validation and Forms
You could try John Walkenbach's Enhanced Data Form. It's a free add-in
that allows combo boxes, so it could display a list of items. http://j-walk.com/ss/dataform/index.htm Marge wrote: Is there anyway to get a Data Validation List in cells to show up in the Data Form? I have several columns with Data - Validation - List (and lists I created) on the spreadsheet, but when you go to Data - Form, you just get the normal blank cell to enter data into and their is no List. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Validation and Forms
Debra,
Thank you! That worked perfectly! Marge "Debra Dalgleish" wrote: You could try John Walkenbach's Enhanced Data Form. It's a free add-in that allows combo boxes, so it could display a list of items. http://j-walk.com/ss/dataform/index.htm Marge wrote: Is there anyway to get a Data Validation List in cells to show up in the Data Form? I have several columns with Data - Validation - List (and lists I created) on the spreadsheet, but when you go to Data - Form, you just get the normal blank cell to enter data into and their is no List. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Validation and Forms
You're welcome. Thanks for letting me know that it worked.
Marge wrote: Debra, Thank you! That worked perfectly! Marge "Debra Dalgleish" wrote: You could try John Walkenbach's Enhanced Data Form. It's a free add-in that allows combo boxes, so it could display a list of items. http://j-walk.com/ss/dataform/index.htm Marge wrote: Is there anyway to get a Data Validation List in cells to show up in the Data Form? I have several columns with Data - Validation - List (and lists I created) on the spreadsheet, but when you go to Data - Form, you just get the normal blank cell to enter data into and their is no List. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation | Excel Discussion (Misc queries) | |||
| Create template that ignors data list rules | New Users to Excel | |||
| Check Boxes & Data Validation | Excel Discussion (Misc queries) | |||
| using forms in a shared workbook | Excel Worksheet Functions | |||
| Forms Toolbar vs. Control Toolbox vs. Data Validation for drop dow | Excel Discussion (Misc queries) | |||
Linear Mode
