I have 37 major categories that have 2 to 10 sub-categories for each
major. I am trying to create a dialog box that will use a “Combo Box”
to list the major categories (was successful), and then use the data
from the major to output the Sub-categories in “List box”.

I have created NAMED location for all of the 37 sub-categories… I
have tried Vlookup, Indirect, offsets, etc.

Can someone tell where I am going wrong?