Automatic dropdown change

You need an event macro that clears cell C4 whenever a new selection is made in cell C2.

I'm not much of a programmer but I think I can handle this (as long as it doesn't get more complicated!).

Right click the sheet tab and select View Code from the menu
Copy the code below and paste it into the right side of the window that opens.

Please Login or Register  to view this content.

Close the window and return to Excel.

Try it out.

You'll have to save the file as a macro enabled file in the *.xlsm format.

Yeah, I kind of figured there was more to it.

I'm not much of a programmer but I think I can handle this (as long as it doesn't get more complicated!).

At this point someone else will need to take over.

Good luck!

C4 cannot change automatically when you change C2. C2 is referencing a group which has options from which to choose. C2 gives no clue as to what option you want.

There has to be more to this problem than what you are showing. Perhaps what you are tying to do requires a different approach.

Can you post a workbook showing what you are actually trying to do? It appears that you need cascading drop down lists but are not willing to accept that each level of the cascade demands that a choice be made.

I pretty much have the problem diagnosed.

They need an event macro to clear the corresponding cells.

Here's the problem described in a different way...

A1 is a drop down of car makes: Ford, Chevy, Chrysler.

B1 is a dependent drop down of car models.

You select Chevy in cell A1 and Camaro in cell B1.

You change your mind and you now select Ford in cell A1. Cell B1 still displays Camaro which is an invalid selection for Ford. So, you want to clear cell B1 whenever you make a new selection in cell A1.

That is the way the drop down lists are supposed to work. There is no way to know what the choice is going to be in C4 when you change C2 until you go to C4 and make a choice.

A couple of alternatives to the event macro...

1. Use a nearby cell to display an alert message to let the user know that they need to make a new selection from the dependent drop down list.

2. Use conditional formatting to hide the invalid selections from the dependent drop down list. This should alert the user to make a new selection.