VBA-ExtendedDictionary
excel-formula-print
Our great sponsors
VBA-ExtendedDictionary | excel-formula-print | |
---|---|---|
8 | 1 | |
16 | 3 | |
- | - | |
8.1 | 0.0 | |
3 months ago | almost 3 years ago | |
VBA | VBA | |
MIT License | - |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
VBA-ExtendedDictionary
-
Update database with two similar workbooks
If you're working with dictionaries, this might help.
- [EXCEL] Loop theory
-
excel - pasting from dictionary into sheet1
Using u/chunkyasparagus' example values, I populated my cExtendedDictionary and dumped it to the sheet. Took at a guess, nearly a second to run.
-
Best way to query a set of data in vba?
This was one of the things my Extended Dictionary was designed to do with the AddBulk method.
- [EXCEL] Checking one data table for information relative to another one using VBA
- How do i find out how many times a duplicate value appear in a column of data?
-
Where to use class modules
An example of where I've used a class as a tool can be found here.
- [VBA] Record unique values from a collection in an array
excel-formula-print
-
Good general Mechanic Calculation Suite?
Shameless plug, but I wrote an Excel macro that displays the formula in terms of its variables. Makes checking a breeze. And super easy to paste into Word if you are creating a report.
What are some alternatives?
VBA-JSON-parser - Backus-Naur Form JSON Parser based on RegEx for VBA
SQLiteC-for-VBA - SQLite library for VBA wrapping ADODB and SQLite C-language API.
stdVBA - VBA Standard Library - A Collection of libraries to form a common standard layer for modern VBA applications.
vba-macros - Some VBA macros for personal use
VBAUnicodeTools - Tools for working with Unicode in the VB Editor
Export-MS-Project-to-MS-Excel - Export tasks, Gantt chart and resources from MS Project to MS Excel. No additional software or installation required. Using build-in MS Project features (VBA).
QRCodeLibVBA - QR Code generator library in VBA
excel-essential-tools - This is an Excel addin, which extends Excel's default functionaility by more than 50 tools.
VBA-Better-Array - An array class for VBA providing features found in more modern languages
VBA-SQL-Library - Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination.