Forum Discussion
Data Validation List - How to disable autocomplete
I have some drop down lists using Data Validation that are for the convenience of my users. I do not want to restrict data to the list, so I've turned off error messages. However, with the new Auto...
I am afraid you can not disable it.
Maybe you need create a dropdown by yourself.
Maybe you need create a dropdown by yourself.
Thank you. Unfortunately, I have a significant number of files and locations that I have used the data validation drop down that is used in tools by many users. This is a fairly significant undertaking. I do not understand why Microsoft adds a new "feature" without thinking through the ramifications to existing applications. I appreciate you providing the answer, even if I don't like it. Thank you