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