So I have a coded WB that fills out blank cells in a range when clicking on different items in a list. What I want to do is prevent the duplication of items in the list. I'm using a WS change event and need to exit the routine if I have selected an item already in the list. Please see attached.
I've tried several things but can't ever get the variables properly identified in VBA. "Object not defined" type errors. I've been trying to store each name in the list as a variable and then compare it to the active cell. value. The list only has 5 items but the list of available items is quite large.
I hope I explained this properly and thanks in advance for whatever assistance you can provide.
I've tried several things but can't ever get the variables properly identified in VBA. "Object not defined" type errors. I've been trying to store each name in the list as a variable and then compare it to the active cell. value. The list only has 5 items but the list of available items is quite large.
I hope I explained this properly and thanks in advance for whatever assistance you can provide.
