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?

Bob,
I've emailed you a 'Tips of the Week' that I have that, Hopefully, will
put you on the right track.
--
Hope this helps.
Gary Brown


"B~O~B" wrote:

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?

On Jun 27, 12:31*pm, Gary Brown
wrote:
Bob,
* I've emailed you a 'Tips of the Week' that I have that, Hopefully, will
put you on the right track.
--
Hope this helps. *
Gary Brown



"B~O~B" wrote:
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?- Hide quoted text -

- Show quoted text -

Gary,

What my goal is when the file is opened a dialog box will appear. The
user(s) will then select from a list of ~37 items, then they will need
to select from a sub-list of 2 to 7 items. Once they select OK from
the dialogic box it will filet the data to the selection they chose
(using a macro)...

Thanks for the validation email, but, it not what I am looking for
(will be forward it so of my workmates)...