VBA Code to clear multiple dependent drop down lists

Hi!

A Couple of questions here about VBA codes -

I have a form with multiple dependent drop down lists & require the cells containing these lists to clear each time the parent drop down is changed.

I've managed to do this with 2 parent & dependent lists so far using the below code:

Just to briefly explain;
B16 is my first parent list with C16:G16 containing dependants which then clear when B16 is changed
B18 is my 2nd parent list with C18:F18 & B20:G20 containing dependent lists or formulas which then clear when B18 is changed. My formulas have disappeared though so I'm guessing the below code has cleared them out?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I then want my new parent drop down's C27:C42 to clear out D27:E42 - I'm just not sure how to get multiple codes in the sheet.

It's been a very long time (about 14 years) since I last looked at macro's etc so I'm still quite new to this.

If anyone could give some advice on the codes above & if I could be doing things a different way it would be much appreciated

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

Hi,

You forgot to add the Code tags. Since you're new here I've added them for you but please note in the future.

As to your request use a SheetChange event procedure like the one below for VBA Sheet2 code name

Please Login or Register  to view this content.

Adapt for other cells which need to zero others when they themselves are changed.