Validation list that also allows user entry?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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:
 
Uncheck "Show error alert...." under the "error Alert" tab in Data Validation.
 
Angela,

Simply turn off the error message (the third tab of the DV dialog) and Excel will ignore items not
in the list.

HTH,
Bernie
MS Excel MVP
 
Greetings Marcelo. That's a great idea, I have actually applied both
principles and it works great. Thank you so much.
 
thanks for the feedback
glad to help you
regards
Marcelo

"Angela Dennis 911" escreveu:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP Errors with Date formats 1
How To Create a Value Based Upon The Contents of A List 2
list in data validation 4
Using Data Validation via an array to stop manual entries - possib 4
Validation List - adding new entries 20
Data Validation Lists 5
Validation List that will not allow cell to be empty 12
Data validation lists help? 6

Back
Top