I have 5 drop down lists in the B column. I can currently choose a food type(b1) and the respective food type lists will populate the remaining drop downs(b3-b6). On the data tab I have the named ranges and all drop down lists are populated through data validation.
What I would like to do is select a food type and the remaining drop downs would show a default selection. I put item numbers in the A3-A6 labels to show that whatever food type is selected, I would like the food items to show in that order based on the list that is on the data tab (i.e. If "fruits" is selected then the drop downs would show banana, then apple, pear, and orange. If "vegetables" they would show broccoli, carrot, onion, then corn). Every time the food type is changed, the rest of the drop down defaults are populated with the correct defaults, however, if someone is to change the item drop down lists after the initial defaults, they would be able to do without issue.
I understand this is probably a VBA thing and I am quite new to it. I know there is a way to do it by case and type in the string literals, but I would prefer pulling by the position in the list as I have many dependent drop down lists.
Also, I would like to set an initial default for when the workbook is pulled up, so it can show an example of the fully filled out form.
Bookmarks