Excel Helper Library

This is my humble collection of Excel Helpers. There are many like it, but this one is mine.

It is available on Github at https://github.com/ceybers/excel-helper-library.

Why?

In creating VBA projects a large portion of that time and effort is spent on problems that have been solved a long time ago and optimised as much as reasonably possible.

There is no need to repeat yourself and recreate the functionality to be able to check if an item exists in a Collection or implement a Queue or a Stack.

Then there are more interesting patterns, such as having a standard way of storing data in a user specific location, or inside a worksheet where the user cannot accidentally remove it.

None of these are particularly innovative or ground breaking, but rather just my personal collection of reusable code.

Things to do

After many hours of practice and trial and error, I've more or less landed on a generic implementation of the Model-Model View-View pattern that works for me. Heavily based upon the work of Rubberduck VBA, but simplified and condensed down to my use cases. Now I just need to get around to cleaning it up and committing it to code and writing up all the documentation.

I also want to create a sort of personal Design System for Excel VBA UI. If you're familiar, the options available are incredibly outdated, with the most recent being the TreeView and ListView from Common Controls 6.0, circa 2007. In a different world I'd be creating desktop apps using WPF and modern UI controls and coding in C#, but for now the sheer amount of Excel busywork that is necessary to keep the average office from spontaneously combusting makes creating tools in Excel VBA worth the time and effort.

It's just that it feels wrong having to create a UI that looks like it stumbled out of a time machine from 1995.