Validation list via dynamic array in VBA
 

I need to reference custom validation list in Excel. I want to create
the validation list in VBA. The items in the list are not sorted one
after another nor do I want them to be. I want the spreadsheet to be
robust enough to handle an entry anywhere and still build the
validation list.

Here is what I have:

Code Sub-Code
A Cond
B Cond
C Stat
D Cond

What I want to do is build a validation list that contains the "Code".
But, I want only to include items in the validation list that have a
Sub-Code of "Cond".

How would I create this list in VBA?
If a dynamic range is the answer, how would one write it?
Is an array the answer?

Help.

Signed,
Lost

Validation list via dynamic array in VBA
 

Nobody knows how to do this?
Is it not possible?