Making a drop down list from VBA?

Hi,

So I have a small issue.

I have a drop down list that will show different values based on what text another drop down list will show (in other words, the drop down list will show different values (that the user can select) based on what text another cell show).

This works fine if I use the "If" command inside the values of the other drop down list. The problem is, the "iF" command is getting bigger by the minute since I am adding stuff all the time.

Is it possible to make this in VBA? That would make it so much easier to modify.

Maybe a UDF that can be written inside the same place where I write the IF command I write now?

See if this discussion helps:
https://www.excelforum.com/excel-gen...alidation.html