Have not been able to find an example of this but you can also implement dependent drop down lists using the INDIRECT() function. Basically, you do something like the following;
1. Create a number of named areas on the worksheet to hold the data for the dependent drop down lists. Make sure the names of these area match the labels that will appear in the first drop down list of the series. 2. In cell A1 - just as an example, you can use any cell of course - create a drop down list using a comma separated list of values. Each value will be the name of one of the named areas.. 2. in Cell B1 - again this can be any cell but it should be the drop down list whose contents should depend on the value the user chooses in the preceding drop down list - create another drop down list using the INDIRECT() function something like this - INDIRECT(A1). This should determine that the value chosen in the first drop down will identify the named area from which the values should be chosen to populate the second drop down. Sadly, I cannot test this technique myself as I now use OpenOffice exclusively and INDIRECT() does not work with the name of an area as it ought to do with Excel. It should be very easy to test the technique however for yourself. Mark B -- View this message in context: http://apache-poi.1045710.n5.nabble.com/how-to-create-dependent-drop-down-list-in-excel-tp5482135p5494874.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
