VBA-ExtendedDictionary
VBA
Our great sponsors
| VBA-ExtendedDictionary | VBA | |
|---|---|---|
| 8 | 1 | |
| 16 | 407 | |
| - | - | |
| 8.1 | 0.0 | |
| 3 months ago | about 1 year 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
VBA
-
How easy is it to switch industries?
Lots of stock/option trading stuff. Detailed web scrapers. Couple games. Some bioinformatic algorithms. I don’t have em on my website but I automated all the web pages in vba (which is why it isn’t a great website but I’m also not a website developer). So my site and GitHub are good ways to get sample code out there.
What are some alternatives?
VBA-JSON-parser - Backus-Naur Form JSON Parser based on RegEx for VBA
Excel-Pomodoro-Timer - Excel Pomodoro Timer
stdVBA - VBA Standard Library - A Collection of libraries to form a common standard layer for modern VBA applications.
JustMoreVBA - A collection of code snippets, modules, and classes that I've written and collected over the years.
VBAUnicodeTools - Tools for working with Unicode in the VB Editor
add-chatgpt-to-microsoft-word - How to add ChatGPT's Text Completion to Microsoft Word
QRCodeLibVBA - QR Code generator library in VBA
vba-macros - Some VBA macros for personal use
SQLiteC-for-VBA - SQLite library for VBA wrapping ADODB and SQLite C-language API.
Speed-Bionic-Reading - Speed reading technique that has recaptured public interest due to Bionic Reading done in a VBA Macro
VBA-SQL-Library - Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination.
msaccess-vcs-addin - Synchronize your Access Forms, Macros, Modules, Queries, Reports, and more with a version control system.