Need Help altering my VBA code.

Hi,

Please can someone help me to put a couple of issues right?

At the moment when an operator selects Azera, L, M,and N from the drop down menu in cell E it puts a "YES" in cell L, but if the operator was to select say L by mistake and then selected K, the "YES" still stays in cell L.

I would like when I change the letter in cell E drop down menu cell L also changes to suit.

Azera, L, M, and N = YES all the others to say N/A.

Also i'd like it if you could help me so when I deleted whatever is in cell E, its also deleted whats in cell L.

Any help on this would be appreciated.

Kind Regards
Dan

This seems to be identical to your other thread: https://www.excelforum.com/excel-gen...t=#post4608486

Yep, identical thread.
Try this formula:

Formula:

Please Login or Register  to view this content.

and copy down

Hi,

Sorry, I just thought if I entered it in both the General & Programming, i'd hopefully get more people looking at it. I won't do it again.

sintek, thank you for your suggestion. I've entered your formula, but unfortunately once I click yes on the message box after I select from the drop down menu, it overwrites your formula.

Kind Regards
Dan

Hi dan

"Yes" on which message box

I see you've created a rule that formats if cell value contains 'Yes' ????

May i ask why you have the message as follows appear:
message.gif
and when Yes is chosen, column L gets replaced with "Yes" when this is not the criteria required as per original enquiry.

Why this code:

Please Login or Register  to view this content.

The above code is overwriting the formula

Hi Sintek,

OK I now see now what you're saying. My apologies, I forgot to mention that the "YES" is put in cell L by the command of the message box "YES" button.

I need that code/message box to alert the operators to make sure they are doing the job correctly. That's why I attached my file just in case of something like this.

I hope it makes more sense now.

Kind Regards
Dan

I've tried that sintek but it comes up with a run time error 28 out of stack space and when I debug it, its highlights if not intersect (target, range G:G)) is nothing then.

any ideas?

Kind Regards
Dan

Hi Guys....Strange, it worked perfectly on my side earlier.... NOW gives errors as follows:
Untitled-1.gifUntitled-2.gif

Yeah, that is a bit of a tricky one lol

If anyone out there figures out...please post results

Hi Guys,

I've managed to sort it and get what I want by editing the VBA code and also using your formula Sintek.

So thank you for all your help and suggestions, its much appreciated.

Kind Regards
Dan

Good stuff Dan

Pls mark thread as solved and hit the star to add rep points!!!