1) I've managed to populate a validation list based on data from another
Worksheet but I'm wondering if it's possible to populate a list from data in
VBA?

2) Is there another way to create a dropdown list in every cell in all of
Column B with data from VBA?

3) Is there a way to pass my own AutoComplete data to excel from VBA instead
of it looking at the above cells in the column?


THANKS in advance for the ideas

P.S. I'm trying to find a creative way to first select a parent from a list
(data on Worksheet1) and then in the next column list the children
registered to that parent.