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
Convert Formula to Relative or Absolute April 10, 2019
Convert Entire Excel Workbook to Values March 11, 2019
Evaluate with Excel to Extract Sequence March 6, 2019
Extract the First Item from a Horizontal List February 27, 2019
Create Number Sequence with VBA Custom Function January 15, 2019
Protect a Worksheet, Use the Autofilter October 18, 2018
Countifs Across Sheets October 10, 2018
Excel VBA to Select Sheets September 22, 2018
Power BI Desktop Dashboard August 20, 2018
New Excel Dashboard Tools August 1, 2018