This one doesn't make sense to me.
I'm working on a project using data validated lists. For some, I'm leaving the error alert setting on "Stop", and for others I'm using the "Information" setting to permit entry of something other than the specific list values.
I have a situation where I'm not getting a consistent response from these settings. In some cells, I'll have the error alerts set to "Stop" (and the box checked to show the alert), and I can enter text manually without getting any alert warning. Other cells set the same way on the same page work as they should.
Anyone have an idea why or how this could occur?
I use these data validation feature all the time and have never seen this behavior before. I've tried clearing the cells and re-setting them, with the same results. I don't get it...
I'm working on a project using data validated lists. For some, I'm leaving the error alert setting on "Stop", and for others I'm using the "Information" setting to permit entry of something other than the specific list values.
I have a situation where I'm not getting a consistent response from these settings. In some cells, I'll have the error alerts set to "Stop" (and the box checked to show the alert), and I can enter text manually without getting any alert warning. Other cells set the same way on the same page work as they should.
Anyone have an idea why or how this could occur?
I use these data validation feature all the time and have never seen this behavior before. I've tried clearing the cells and re-setting them, with the same results. I don't get it...