mark hansen
Well-known Member
- Joined
- Mar 6, 2006
- Messages
- 534
- Office Version
- 2016
- Platform
- Windows
I thought I saw this up here somewhere but can't find it.
I'm looking for a way to stop a user from selecting an item from a drop down box, if that item has been selected before.
Example
I have a group of cells A10:A15. Each one of those cell has data validate to have a drop down box from my list.
then the user selects and item from the list... No problem.
If they move down and select an different item ... No problem.
BUT if in the third box, they then try to select the same item in either of the two boxes, they are not allowed. Warning message and all that.
I saw something like this up here before and I normally try to save things like that but I guess I let that one slip by. Its wasn't with macros it was something else.
Thanks for any help.
Mark
I'm looking for a way to stop a user from selecting an item from a drop down box, if that item has been selected before.
Example
I have a group of cells A10:A15. Each one of those cell has data validate to have a drop down box from my list.
then the user selects and item from the list... No problem.
If they move down and select an different item ... No problem.
BUT if in the third box, they then try to select the same item in either of the two boxes, they are not allowed. Warning message and all that.
I saw something like this up here before and I normally try to save things like that but I guess I let that one slip by. Its wasn't with macros it was something else.
Thanks for any help.
Mark