Auto update of indirect list when parent validation list is re-selected.

Hello All,

I'm creating a sales pricing worksheet in which the user will select products with some of those products having an indirect list of associated options. Both the validation list and indirect dependent list are populating with the correct information. However, I need the indirect dependent list to auto update should a user re-select their item in the initial validation list. Othewise the indirect list won't update unless physically clicked upon.

I've located a code while scouring the web that I have been successful using solely on my first validation list/indirect dependent list. I've now come to my next unrelated validation list/indirect dependent list (which I might add is in the same column) and I cannot figure out how to add it to the VBA code. The code snapshot below is the code that I've used for the first Vlist/Ind Dep list. My next validation list and subsequent indirect dependent list would be in cells E15 and E16. These new lists are unrelated to my initial cells.

Please Login or Register  to view this content.

I thought maybe I could stack the codes such as shown below, but of course I hit the Ambiguous name detected:worksheet_change error.

Please Login or Register  to view this content.

Thanks in advance for any assistance,
Chris

Originally Posted by AlphaFrog

Don't you just want to clear the current entry of the dependent list if its parent list changes?

If yes, try this...

Please Login or Register  to view this content.

Add more parent list cell addresses (bold) to suit.

Thank you AlphaFrog! Works as I needed and I added "Please Select" to the Target.Offset as well.

Originally Posted by AlphaFrog

Don't you just want to clear the current entry of the dependent list if its parent list changes?

If yes, try this...

Please Login or Register  to view this content.

Add more parent list cell addresses (bold) to suit.

Hey Alpha,

If you happen to stumble back into this thread, I do have a followup question. Adding to the E6,E15 for subsequent resets, If I skip rows and have a new unrelated validation list with an indirect in the same column, how would I go about adding those in. So ("E6,E15") and then new unrelated list ("E20,E23").

Chris

Originally Posted by AlphaFrog

If Not Intersect(Range("E6,E15,E20,E23"), Target) Is Nothing Then

Thanks for checking back. I tried what you noted earlier in the thread but now realized I forgot to add my indirect to the parent validation which was causing me the grief. Thanks for the follow up.