Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using LINEST for non-linear curve fitting
- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Contour plots with Excel and Matplotlib
- Cubic Splines
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Downloads by category
Recent Comments
Benata on Ana Vidović mindOnion on Drawing a Buckyball in Ex… dougaj4 on Drawing a Buckyball in Ex… mindOnion on Drawing a Buckyball in Ex… mindOnion on Drawing in Excel 7 – Cre… Veronica Davenport on Asymmetric Catenary Function py_UMom spreadsheet… on More on combined shear and ben… Skip on xlwings – dataframes and… dougaj4 on xlwings – dataframes and… More on combined she… on RC Design Functions 9.03; comp… skip on xlwings – dataframes and… skip on mpmath for Excel dougaj4 on mpmath for Excel skip on mpmath for Excel dougaj4 on Composite Beam Spreadsheet Upd…
Tag Archives: scripting dictionaries
Dictionary link
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.
All about dictionaries
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
Daily Download 33: Miscellaneous
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
Units for Excel 4: Scripting dictionaries
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 Conversion, Excel, scripting dictionaries, UDF, Units, Units aware, VBA
6 Comments