I have a (well-functioning) drop-down box that gives me various choices. Once I've chosen the item I want from that drop-down box, I have managed to get displayed, in another drop-down box, the relevant sub-objects that are relevant to the choice I made in the first drop-down box. I did that by means of an HLOOKUP function elsewhere that selects a list by looking up the data from an array. That all works fine.
However, when I select my main choice in the first drop-down box, I still see, in the second drop-down box, the list from my previous choice. Only when I click the down-arrow for the second drop-down box do I then get the list within that drop-down box that I want, the list that is relevant to my main drop-down box. The problem will be that unless the user of my spreadsheet thinks to actually click the down-arrow in the second drop-down list, she/he may well think that the choices displayed in the second drop-down box are relevant, which they will not be if the main choice has changed.
Is there a way to make my second (dependent) drop-down box automatically display the correct choices based on the selection in the first (main) drop-down box?
I have come across this sort of issue before, and someone solved the problem by means of VBA, but (a) I'm not adept at VBA, and (b) is there a way to do what I want without using VBA? If there isn't, is there someone who can simply explain to me how to code for this?