VBA Excel - How do I clear the contents of a cell but retain the ability to edit that cell after it is cleared?

[Sfusco]

Hello -
I have a drop down with two options. The two options are "Good" and "No good". If "Good" is selected the adjacent three cells are filled with "N/A". I want to have the second drop down option "No good" trigger clearing the adjacent three cells, yet allow me to utilize the drop downs that are set for those three cells after they are cleared. The code I have written clears the three adjacent cells, and continues to clear the values I select from the dropdowns. Net result is I can't populate the adjacent three cells. I don't know how to work around this issue. I am currently using the worksheet_SelectionChange event. I have tried to toggle the Application.EnableEvents around the actionable code, but I am still not able to get it to work properly. Any guidance would be greatly appreciated.
Thanks so much for any help.

 

[Fluff]

Hi & welcome to MrExcel.
If the drop downs are data validation, then use the worksheet change event, rather the selectionchange event.

 

[Sfusco]

Hi & welcome to MrExcel.
If the drop downs are data validation, then use the worksheet change event, rather the selectionchange event.

Hello Fluff -

Unlike your name, you are sharp as a tack. Thank you so very much for your timely and accurate response. Your advise did the trick. I can't say that I understand why that simple change made the difference, but it works like a charm now.

and thanks for the welcome!

Kindest regards

 

[Fluff]

With the selection change, when you go to select something from the drop down, it triggers the event thus clears your selection.