Validation list via dynamic array in VBA

[Brady]

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

 

[Brady]

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