| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I un-restrict my drop down list field on a template?
Hi there - I've got a field/column set up as validated data with a large
amount of options to choose from in a drop-down list. Here are the issues my users are having: 1) they have to actually select the choice before they can access it in future records 2) they want the ability to type in whatever they want (w/o having to choose from the list) ... is there a way to give them that option? please advise! Thanks! ~k. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I un-restrict my drop down list field on a template?
Turn off Error Alert if the DV is a List
Gord Dibben MS Excel MVP On Mon, 6 Aug 2007 13:26:02 -0700, Kara7 wrote: Hi there - I've got a field/column set up as validated data with a large amount of options to choose from in a drop-down list. Here are the issues my users are having: 1) they have to actually select the choice before they can access it in future records 2) they want the ability to type in whatever they want (w/o having to choose from the list) ... is there a way to give them that option? please advise! Thanks! ~k. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set a "fillable" field in a drop-down list in Excel? | Excel Discussion (Misc queries) | |||
| Creating a drop down list that modifiys the next field. | Excel Discussion (Misc queries) | |||
| Restrict drop downs | Excel Discussion (Misc queries) | |||
| How to restrict entry or color the field | Excel Discussion (Misc queries) | |||
| HOW TO RESTRICT DATA ENTRY FROM A CHOICE OF SEVERAL LIST? | Excel Discussion (Misc queries) | |||
Linear Mode
