ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Create a cascading list box using Excel (https://www.excelbanter.com/excel-discussion-misc-queries/14855-create-cascading-list-box-using-excel.html)

JPB

Create a cascading list box using Excel
 
A cascading list box is a list box with choices that change based on the
value a user selects in another list box. For example, clicking Condiments
in the Categories box causes the Products box to display a list of
condiments. This example comes from an Access 2003 solution. Can it be done
using Excel 2000?

Bob Phillips

See

http://www.xldynamic.com/source/xld.Dropdowns.html
Dynamic Dependent Dropdowns

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JPB" wrote in message
...
A cascading list box is a list box with choices that change based on the
value a user selects in another list box. For example, clicking

Condiments
in the Categories box causes the Products box to display a list of
condiments. This example comes from an Access 2003 solution. Can it be

done
using Excel 2000?





All times are GMT +1. The time now is 09:54 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com