Help with a worksheet control to govern column data entry ...

Hi all - new to VBA and trying to get this to work - any assistance is grateful.

I am looking to control data entry in one of two worksheet columns (14 and 16) -such that data entry will only be accepted in one column OR the other, but not both.

Ideally, the code should behave such that once text (from a drop down list) is selected in one column (14 or 16), nothing occurs (e.g.this is acceptable), however, once text is selected in BOTH columns (14 AND 16), the other cell is deleted and a message box is thrown indicating that one or the other can contain text, but not both.

Here is what I have so far:

Please Login or Register  to view this content.

However, this does not seem to work. Any ideas?

Please Login or Register  to view this content.

Ok I tried the above and still doesn't seem to work - I am wondering if a boolean is not the best approach for this?

Many thanks again!

Ok thanks Wes - I will give your code a shot and report back - somehow mine is not functional as is ...

Cheers
-Steve

Originally Posted by OmegaWes2012

NikonMan - My apologies, I wasn't able to test the code you provided before, but I did test the block of code below. As I am fairly new to VBA, I would assume one of the moderators might be able to provide a better, more efficient solution.

Please Login or Register  to view this content.

This worked for me when I tested it. I've also attached the test file I used.

Hope this helps.

Wes

This code works great - thanks so much!