Hi Kashgarinn,

I have a sample workbook that creates these sort of lists, as many as you
wish. However, the way I have built is to have all of list 3 in column C,
list 2 is in column B, duplicated to align with C, and similarly with A. So
the data might look like

galaxy A const A-A solar A-A-A
galaxy A const A-A solar A-A-B
galaxy A const A-B solar A-B-A
galaxy B const B-A solar B-A-A
galaxy B const B-B solar B-B-A
galaxy B const B-B solar B-B-B

If you are willing to structure your data this way, you are welcome to a
copy of my workbook to implement on.

I have a control toolbox combobox version, and a data validation dropdown
version (no forms or userform combo versions yet). If you want a copy, email
me directly and say which you want.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Kashgarinn " wrote in message
...
Greetings.

Thank you for reading this, I hope you can help me.

on worksheet 1 I would like to create 3 drop-down lists.

The first drop-down list displays 66 values (in this case names of
galaxies), values which are in column A on worksheet 2. In column B on
worksheet 2, there is a serial number for each of the 66 names.

Example: on worksheet 2, A1 = "derelik" and B1 = 10000001

Here comes my problem:

On worksheet 3 there is a list of constellations within each galaxy,
each constellation has its own serial number (for instance "San matar"
which has the serial number "20000001"). So on worksheet 3 there is in
column A the galaxy serial number of the constellation, in column B
there is the constellation serial number, and in column C there is the
name of the constellation.

Then in worksheet 4, there are the individual names of each
solarsystem, their respective serial number (for instance: "EH2I-P"
serial: 30005108), the constellation serial which they're in, and the
galaxy serial that solarsystem is in.

So what I want to do is this:

From the first drop-down list I choose the galaxy.

From the second drop-down list I get a choice of _only_ the
constellations within that galaxy.

From the third drop-down list I get a choice of _only_ solarsystems
within that constellation.

Is this possible? If so, can you help me?

Thanks for any replies.

K.


---
Message posted from http://www.ExcelForum.com/