spectraflame
Well-known Member
- Joined
- Dec 18, 2002
- Messages
- 829
- Office Version
- 365
- Platform
- Windows
I have cells on Sheet1 that have data validation in a drop down list which are referencing a defined range (=CALL_TYPE) from another sheet in the same workbook. I also have an error alert defined with a simple message that asked the user to choose an item from the list.
I was thinking that if I keyed in anything that was not in the list, I would get the error message pop up. That does not seem to be the case. Even though I have my choices in the list and I can choose any one of them, I can also key in any other value and not get any alert at all.
Am I missing something or doing something wrong?
Matthew
I was thinking that if I keyed in anything that was not in the list, I would get the error message pop up. That does not seem to be the case. Even though I have my choices in the list and I can choose any one of them, I can also key in any other value and not get any alert at all.
Am I missing something or doing something wrong?
Matthew