List boxes - Are sub lists possible?

  • Thread starter Thread starter fortworthphil
  • Start date Start date
F

fortworthphil

I need to figure out if its possible to have multi-level list boxes.
need a list box that has approximately 70 options; when you select on
of the 70 options I need another list box (sub list?) to open giving u
to 10 choices based on what was selected from the first list of 70
I've spent 2 hours searching for information on this and can't seem t
correctly ask the question. It is basically a 2 level list box tha
would work much like the Excel menu. The first level is genera
categories. The second level needs to expand based on what you chose i
the first level. Any help would be very appreciated.
Thanks.
Phi
 
You can even do it with Data|Validation.

Debra Dalgleish has some instructions at:
http://www.contextures.com/xlDataVal02.html

If that doesn't give you any ideas, you may want to post back with some more
info:

Where are the listboxes located (userform or worksheet)?

If a worksheet, are they from the control toolbox toolbar or from the Forms
toolbar?

Do you have the data to use in a worksheet?

Column A has all 70 items:
column B has the stuff associated with the first item.
column C has the second, etc
 
Hi Phil,

Try this approach (requires VBA)
make a form with two listboxes. the one on the left is filled with your 70
options. When the user selects an entry in the left listbox then use the
listbox_Change event to clear the the right-hand listbox and populate it
with the appropriate subchoices.
(or you could just show another form)

Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm
 
Back
Top