Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
pick from 'drop down list' OR enter text in cell
Greetings,
I often use the drop down list feature from data validation in many cells on forms for ease of form filling. Would like to do same but also allow the user to type in her own text if nothing on the drop down list is suitable. Is this possible? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
pick from 'drop down list' OR enter text in cell
Hi David
Yes On the DV validation dialogue, go to the error tab and untick the box. -- Regards Roger Govier "David" wrote in message ... Greetings, I often use the drop down list feature from data validation in many cells on forms for ease of form filling. Would like to do same but also allow the user to type in her own text if nothing on the drop down list is suitable. Is this possible? Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
pick from 'drop down list' OR enter text in cell
Thanks Roger,
That has been a tremendous help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct issues | Excel Worksheet Functions | |||
change size of in cell drop down list | Excel Discussion (Misc queries) | |||
How can I wrap text in a drop down list? | Excel Worksheet Functions | |||
How do I make a drop down list to pick from for a cell in Excel | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions |