ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Conditional List dropdowns? (https://www.excelbanter.com/excel-discussion-misc-queries/246676-conditional-list-dropdowns.html)

GD

Conditional List dropdowns?
 
Hi, i'm looking to add a condition to certain list drop-down options based
upon the selection in a prior dropdown, is this possible?

For example dropdown A, you can select Red, Blue or Green
Dropdown B, if they have selected Red - they can choose between Car, Van,
Bike. If they have selected Blue then it is Boat, Plane, Walk etc...so the
selection choices in dropdown B are contingent on the selection in dropdown A


Jim Thomlinson

Conditional List dropdowns?
 
Check out thsi link...

http://www.contextures.com/xlDataVal02.html
--
HTH...

Jim Thomlinson


"GD" wrote:

Hi, i'm looking to add a condition to certain list drop-down options based
upon the selection in a prior dropdown, is this possible?

For example dropdown A, you can select Red, Blue or Green
Dropdown B, if they have selected Red - they can choose between Car, Van,
Bike. If they have selected Blue then it is Boat, Plane, Walk etc...so the
selection choices in dropdown B are contingent on the selection in dropdown A



All times are GMT +1. The time now is 11:52 AM.

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