How to use List Box/Combos

[Joozh]

Hi,

I need some quidance regarding how to use List boxes/combos in Excel.

Thanks,

-J

 

[PaddyD]

what do you want to do with them - usually, the more specific the question, the better / more helpful the answer you'll get.

paddy

 

[Joozh]

what do you want to do with them - usually, the more specific the question, the better / more helpful the answer you'll get.

paddy

Hi,

Sorry for not providing enough details. Here's what I want to do:

I want to use a list/combo with 2 columns. Suppose I am in a column called Department. In any cell of this column I want to be able to pull down a combo/list having 2 columns (Dept, Employee) i.e. pulling down the combo should show me a department wise list of all employees... When I select any of the entires from the list, my Dept. column should get filled with the selected department while my next column (which would be Employee column) should get filled with the employee whose entry was selected in the list just discussed.

I tired doing this using Data Validation, but could not get it to work and display more than one column.

 

[PaddyD]

the following quote is from Aladin:

"The method is as follows:

Enter in some column what follows:

{"USA";"FRANCE"}[ That's, enter USA in a cell, then FRANCE in the next cell down ]

Select these cells, go to the Name Box on the Formula Bar, and type COUNTRIES followed by enter.

Enter in a column next to COUNTRIES:

{"New York";"Pittsburgh";"Los Angeles";"Boston"}

Name this range of cells USA via the Name Box as described above.

Enter in a column next to USA:

{"Paris";"Nice";"Toulon"}

Name this range FRANCE.

Just to see how this works,

activate A1 in some worksheet in the same workbook;

activate Data|Validation;

choose 'List' for 'Allow';

enter as 'Source' the formula:

=COUNTRIES

click OK;

activate another cell in the same worksheet, say, C1;

activate Data|Validation;

choose 'List' for 'Allow';

enter as 'Source' the formula:

=INDIRECT(A1)

click OK.

Now you have two lists of which the 2nd depends on the selection from the 1st. "

 

[Joozh]

Many thanks. Tough this does not totally solve my problem but the suggestion was really helpful... I was doing the same thing using a pretty 'convoluted' approach and your suggestion is much simpler.

Thanks for the help

Regards,

- J