Hi all,
I need to make a form, where it is possible, to make selection from multiple dropdown menus.
The "basic" datavalidation is not ok, as I have several overlapping items.
I have a table similar to this (obviously bigger):
Please Login or Register to view this content.
I need dependent dropdowns, where I can make a selection from left to right, and the dropdown shows only the available options.
VBA solution is also fine, I'm happy to learn it.
Thanks!
Here are two different ways of doing this: one with VBA and the other without.
http://www.utteraccess.com/wiki/inde..._%28Non-VBA%29
http://www.utteraccess.com/wiki/inde...ists_%28VBA%29
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Thanks, but unfortunately it is not good for me.Originally Posted by dflak
If there is overlapping, it is not working fine
(If you download, and try it, for example put Florida to any other region, and if you select the region - Florida, it will still list every city from Florida, even from other region, not only the choosen one)
You need to post a workbook with more realistic examples
Ben Van Johnson
pls find it attached.
Here is the cascading dropdowns using the VBA method. Because of the overlap, I am not sure the non-VBA method would work.
This method uses pivot tables. As you select a value, it sets filters in the other pivot tables "down stream." The results of each pivot table are "overlaid" with named dynamic ranges. These names are used to drive the data validation for the drop down lists.
Thank you dflak
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks