Using dialog box

[B~O~B]

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?

 

[Gary Brown]

Bob,
I've emailed you a 'Tips of the Week' that I have that, Hopefully, will
put you on the right track.

 

[B~O~B]

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







- 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)...