Add Clear and Loop Function to Macro Code

[SVTF]

Hello Pro's

This is for excel 2010

I am looking to either add a clear option and or a loop function to the follow macro code.
This code is working 100% however I need to add a clear option or a loop function when N/A is selected from the drown options in H

So as per the code below – When N/A-Must add comment is selected – Column I (same row) is prefilled with N/A - And the user would have entered something in Column J (same row) – Works as it should.
However there could be an instances when N/A-Must add comment could be changed to either No or Yes.

What can be added to the code below that if "N/A-Must add comment" is changed to either No or Yes…

•It will clear the data in Column I and J same row
•And then follow the rules in code for Yes and No

[SVTF]

Here is a test workbook

Thanks in advance.

[SVTF]

I have seen some examples of clear contents VB code - which I think would work.
Just not sure how to include it in the above code around the N/A part of the code?

Thoughts? Suggestions?

It would have to be a targeted clear. Only clear I and J when "NA Must add comment" in H is changed to No or Yes and then follow the rest of code function.

Need more info?

[SVTF]

Any of you excel peeps that are 1000% more versed than I able to help me out with this?

So just clarify the code currently works as needed but need to modify to include.

If the "N/A-Must add comment" is changed.... Clear data in Column I & J same row. And then loop back around so that the code works for what ever selection is made....

Ie.

NA to No... Clear data in I and J and follow No code.

NA to Yes... Clear data in I and J and follow Yes cone.

Or even

NA is deleted and for some reason re-selected... Clear data in I and J and follow NA code.

[SVTF]

Thought I had something. Guess not.

[SVTF]

Looks like it might be as easy as adding:

Please Login or Register  to view this content.

However I also need to clear column 10 same row ...

How can I expand the range in the above code?

Because the above only clears Column I

[SVTF]

Solved

Please Login or Register  to view this content.