Dependent and Non Dependent Comboboxes
Cascading combo boxes have been done online and I had a problem recently which knocked me for 6 as we say here in Australia. Anyone who deals in cascading combo boxes will know only too well that if you are using a list and the Indirect formula to manage the combo boxes then the process can get very unruly very quickly. One of the issues with comboboxes is that they are set up to work in sequence. Combo box 1 feeds into combobox 2 which feeds combo box 3. The combo boxes need to be filled out in that order.
Read MoreFeatured Posts
Recent Posts
XLookup to the Party August 31, 2019
Populate a Userform with VBA August 14, 2019
New Dashboard Ideas August 9, 2019
Excel Custom Sort August 7, 2019
Excel VBA Remove Duplicates Multiple Columns August 6, 2019
The Tennis Chart July 17, 2019
Smallman Interview July 15, 2019
Excel Summit South 2019 July 12, 2019
Sales Excel Dashboard June 14, 2019
Using the Wildcard with SUMPRODUCT May 30, 2019