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
Populating an Excel Table from a Range of Cells with VBA June 12, 2025
Fuzzy Distribution with Randbetween May 21, 2025
Add Minimum and Maximum for Chart in Cells March 12, 2025
Inflation Over Multiple Years in a Single Cell January 10, 2025
Hubspot Dashboard October 3, 2024
Monthly Dashboard With Supporting Metrics September 25, 2024
Excel Show Missing Sheet Tabs July 29, 2024
Run Macro Overnight Automatically June 24, 2024
Split File into Parts and Save to Directory April 20, 2024
Most Popular Author December 14, 2023