Clear Dependent Drop Down By Column

[kellier180]

Hi,

Ok so my problem is I have a number of dependent drop downs in one sheet. All on different columns

So for example D16 is dependent on the selection in D15. Then F16 is dependent on the selection in F15 and so on.

I have the below code which resets D16 if D15 is changed. But I need it to do the same for all columns individually.

So if I change F15 it resets F16 and so on.

Code:

If Target.Address = "$D$12" Then
Range("D13").Value = "Select From Drop Down"

End If

Thanks

[Arkadi]

See the yellow banner at the top of the page for how to attach a sample file, it makes it much easier to put together code for your layout. It also helps eliminate confusion on understanding, for example your description talks about relation between row 15 and 16, yet your code sample uses 12 and 13.

[kellier180]

Thanks for the reply.

I have a sample of what i mean attached now.

In the sample if you change B2 then B3 will change to "Select From Drop Down"

What I'm looking to do is have the same code but do it for cells C2, C3 and so on

Hope this helps
Thanks

[Fluff13]

How about

Please Login or Register  to view this content.

[Arkadi]

kellier180, thanks for clarifying and providing a file
I won't post any code at this time, since Fluff13 beat me to it, and it looks like the ideal way to approach the issue.

[kellier180]

How about

Please Login or Register  to view this content.

That works perfect thanks for your help

[kellier180]

kellier180, thanks for clarifying and providing a file
I won't post any code at this time, since Fluff13 beat me to it, and it looks like the ideal way to approach the issue.

No problem thanks for the suggestion.

Have it sorted

[Fluff13]

You're welcome & thanks for the feedback.

[kellier180]

Just on this.

In my actually excel sheet I have around 20 dropdown boxes for different selections in each column.

Is there a way to have a button whereby when clicked. It would reset all the dropdown boxes for that specific column to whatever text i wanted in this case "Select From Drop Down"? But leave the dropdown boxes in other columns?

I should also say in between some drop down boxes is text that i would need to stay there when the drop down boxes are reset

Sorry I'm not sure how to upload an example for this.

Thanks again

[Fluff13]

You could use a double click event, rather than a button.
Double click in B1:G1 & the 20 cells below will reset

Please Login or Register  to view this content.

[Fluff13]

This will only do DV cells

Please Login or Register  to view this content.

[kellier180]

That's perfect Fluff13

Thanks for your help

[Fluff13]

My pleasure.