Hi friends!

I would be grateful if you could help me with the VBA code. I would like to have programmed behavior of a drop-down list, let's call it "Test", the content of which changes depending on the selection from the list.
Let me explain.
Initially, the list has items "A", "B" and "C".
When "A" is selected, the drop-down list is automatically populated with options "A.I", "A.II" and "A.III".
If "A.I" is selected, the list is automatically populated with the new entries "A.I.a", "A.I.b" and "A.I.c".


If "A.I.a" is selected, the list is again automatically populated with the new entries "A.I.a.1", "A.I.a.2" and "A.I.a.3".
All possible combinations should be available, e.g. "A.III.a.3" "C.II.a.1" "B.I.c.3", etc.
Is this realistic?