Using dialog box

  • Thread starter Thread starter B~O~B
  • Start date Start date
B

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?
 
Bob,
I've emailed you a 'Tips of the Week' that I have that, Hopefully, will
put you on the right track.
 
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 -
Click to expand...

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