I recently discovered this little challenge rather strong! In a UserForm, I have 3 combobox that are based on selections made in the past:
1st combobox = defined area called LIST_GRP
2nd combobox fed according to the selection of the first list by the formula = INDIRECT (LIST_GRP)
3rd combobox: same principle as for the 2nd (= INDIRECT (combobox2))
Except that apparently the combobox, it does not work as a validation list in which the INDIRECT function is accepted!
My question is, how to make dynamic lists feeding my 3 combobox?
Bookmarks