Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation list that also allows user entry?
We have created an Excel radio log for our dispatchers to use to track all
phone calls, EMS and Law Enforcement traffic. We have some dispatchers that are not good typists, and we have repeated traffic in some instances. I am trying to create a validation list for the constantly used terms (Exp. "On Duty, In service, Off Duty, On scene....), so the one finger typers can quickly use the drop down list to save them some time. But, we also need to be able to manually enter into the cell as well. I have not figured out how to make it do both. When I create a list, it will not allow you to manually key into the field, it will only allow you to pick from the list. Is this possible? And if so, how do I do this? Thanks in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation list that also allows user entry?
Hi Angela, another way to save time opn this matter is use the auto
correction you can create eg. when you type OD excel will change to On Dutty, or something like this hth regards from Brazil Marcelo "Angela Dennis 911" escreveu: We have created an Excel radio log for our dispatchers to use to track all phone calls, EMS and Law Enforcement traffic. We have some dispatchers that are not good typists, and we have repeated traffic in some instances. I am trying to create a validation list for the constantly used terms (Exp. "On Duty, In service, Off Duty, On scene....), so the one finger typers can quickly use the drop down list to save them some time. But, we also need to be able to manually enter into the cell as well. I have not figured out how to make it do both. When I create a list, it will not allow you to manually key into the field, it will only allow you to pick from the list. Is this possible? And if so, how do I do this? Thanks in advance |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation list that also allows user entry?
Uncheck "Show error alert...." under the "error Alert" tab in Data Validation.
"Angela Dennis 911" wrote: We have created an Excel radio log for our dispatchers to use to track all phone calls, EMS and Law Enforcement traffic. We have some dispatchers that are not good typists, and we have repeated traffic in some instances. I am trying to create a validation list for the constantly used terms (Exp. "On Duty, In service, Off Duty, On scene....), so the one finger typers can quickly use the drop down list to save them some time. But, we also need to be able to manually enter into the cell as well. I have not figured out how to make it do both. When I create a list, it will not allow you to manually key into the field, it will only allow you to pick from the list. Is this possible? And if so, how do I do this? Thanks in advance |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation list that also allows user entry?
Thank you so much, that was just to simple.
"Toppers" wrote: Uncheck "Show error alert...." under the "error Alert" tab in Data Validation. "Angela Dennis 911" wrote: We have created an Excel radio log for our dispatchers to use to track all phone calls, EMS and Law Enforcement traffic. We have some dispatchers that are not good typists, and we have repeated traffic in some instances. I am trying to create a validation list for the constantly used terms (Exp. "On Duty, In service, Off Duty, On scene....), so the one finger typers can quickly use the drop down list to save them some time. But, we also need to be able to manually enter into the cell as well. I have not figured out how to make it do both. When I create a list, it will not allow you to manually key into the field, it will only allow you to pick from the list. Is this possible? And if so, how do I do this? Thanks in advance |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation list that also allows user entry?
Greetings Marcelo. That's a great idea, I have actually applied both
principles and it works great. Thank you so much. "Marcelo" wrote: Hi Angela, another way to save time opn this matter is use the auto correction you can create eg. when you type OD excel will change to On Dutty, or something like this hth regards from Brazil Marcelo "Angela Dennis 911" escreveu: We have created an Excel radio log for our dispatchers to use to track all phone calls, EMS and Law Enforcement traffic. We have some dispatchers that are not good typists, and we have repeated traffic in some instances. I am trying to create a validation list for the constantly used terms (Exp. "On Duty, In service, Off Duty, On scene....), so the one finger typers can quickly use the drop down list to save them some time. But, we also need to be able to manually enter into the cell as well. I have not figured out how to make it do both. When I create a list, it will not allow you to manually key into the field, it will only allow you to pick from the list. Is this possible? And if so, how do I do this? Thanks in advance |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation list that also allows user entry?
thanks for the feedback
glad to help you regards Marcelo "Angela Dennis 911" escreveu: Greetings Marcelo. That's a great idea, I have actually applied both principles and it works great. Thank you so much. "Marcelo" wrote: Hi Angela, another way to save time opn this matter is use the auto correction you can create eg. when you type OD excel will change to On Dutty, or something like this hth regards from Brazil Marcelo "Angela Dennis 911" escreveu: We have created an Excel radio log for our dispatchers to use to track all phone calls, EMS and Law Enforcement traffic. We have some dispatchers that are not good typists, and we have repeated traffic in some instances. I am trying to create a validation list for the constantly used terms (Exp. "On Duty, In service, Off Duty, On scene....), so the one finger typers can quickly use the drop down list to save them some time. But, we also need to be able to manually enter into the cell as well. I have not figured out how to make it do both. When I create a list, it will not allow you to manually key into the field, it will only allow you to pick from the list. Is this possible? And if so, how do I do this? Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto updating list | Excel Worksheet Functions | |||
Changing Where Data Validation List Boxes Open in Mac Excel 2004 | Excel Discussion (Misc queries) | |||
Validation List Advise Please | New Users to Excel | |||
Data Validation and Blanks in List | Excel Worksheet Functions | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) |