Tag Archives: scripting dictionaries

Dictionary link

Posted on December 24, 2013 by dougaj4

The VBA Scripting Dictionary object is very useful (examples here and here), but the documentation is poor. This is fixed at Data Dictionary in VBA – Complete Syntax Documentation, which provides just what it says.

Posted in Excel, VBA | Tagged , , , | 1 Comment

All about dictionaries

Posted on October 24, 2013 by dougaj4

A couple of links to sites with comprehensive information on using the scripting dictionary object, found via Daily Dose of Excel: VBA for smarties I. What is a dictionary ? A dictionary in VBA is a collectionobject: you can store … Continue reading →

Posted in Excel, VBA | Tagged , , | 2 Comments

Daily Download 33: Miscellaneous

Posted on October 21, 2012 by dougaj4

This is the last of the month and a bit of Daily Downloads, and consists of a bumper bundle of 20 spreadsheets with miscellaneous functions that didn’t fit in elsewhere: Repeating a set of data: for instance making three copies of … Continue reading →

Posted in Arrays, Computing - general, Excel, UDFs, VBA | Tagged , , , , , , , , , | Leave a comment

Units for Excel 4: Scripting dictionaries

Posted on August 8, 2012 by dougaj4

As mentioned in the previous post I have now updated the Units4Excel spreadsheet with the use of scripting dictionaries to speed up the process of finding units in the lists, and also to simplify the process of adding or deleting units.  … Continue reading →

Posted in Excel, Newton, UDFs, VBA | Tagged , , , , , , | 6 Comments