Scripting Dictionary with Ranges

Check to see if folder exists, VBA.

Tags Excel, scripting dictionary, Range

Excel vba Scripting Dictionary

The Excel scripting dictionary from the ground up. This blog post explains how the dictionary interacts with practical examples with an explanatory video series .

Tags Excel, scripting dictionary, How to

Full and Part Summaries with the Dictionary

Creating summaries using the Excel VBA scripting dictionary is something you will want to learn. The dictionary is powerful and can summarise data very quickly. This blog post takes you through the process of using the Excel Scripting Dictionary.

Tags Excel, scripting dictionary, Sum, Multiple, Columns

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.

Tags Combo boxes, not linked, vba, scripting dictionary, linked