What?, Why?I have been inspired by several other posts on the topic of OOP implementations in VBA to try and create a Pacman clone. I think this task is not all that hard in most languages; but, I ...

Any future updates can be found at Excel-VBA-ProgressBarWhat I've been using so farFor the last 6 years I've been using a progress form which I wrote in VBA using just Windows API calls. The code (...

For latest additions, see Edit sections at the bottom of this question.VB6 / VBA is slow to deallocate class instancesVB* class instance deallocation becomes exponentially slower the more instances ...

I'm making a full-blown OOP Battleship game in VBA (previous post: Battleship Grid), and I want this code to be as good as it gets - and better, if I can.I've refactored a few things, introduced a<...

I've written an API that unlocks some serious MVVM capabilities with VBA'sMSForms UI framework.This is the complete code-behind for an example ...

This is the application for small school, which will store students' info in Firebase and also retrieve data from Firebase. I am using JSON Parser to parse the data and save the same in Access tables....

AboutThis is a follow-up of a previous question Private VBA Class Initializer called from Factory. I've decided to create a new question instead of answering my old question because I would like the ...

MotivationI am interested in optimising the execution time of code with short (fast) execution times on the order of microseconds (µs), but that will be used with high frequency (e.g. like ...

I was asked for an example of a class to wrap dynamically added controls as I suggested in this Answer. Although it is out of the context of a Code Review, I thought that it would make an interesting ...

The entry point is theMacros module, which - for now - includes only a single procedure, at a very high abstraction level - I'm quite happy with this:...

This class encapsulates a 2D Array and a Scripting Dictionary. Values are add or returned from to the Array using a Key and aColumnIndex, e.g. ...

After having to swap the feature rich System.Text.StringBuilder for the very fast but very vanilla A lightning-fast StringBuilder, I decided it was time create a ...

I've written my own UI for Mathieu Guindon's VBA Battleship (Battleship UI: GameSheet) which uses a webpage in a WebBrowser control for the View.Webform:Userform...

The preeminence is to have every method of the formatter return the formatter as a reference. This allows it to add and format text in chain. Such as:...

My goal: to make the already easy task of filling out an excel sheet 1% easier by putting in hours and hours of effort. On a more serious note, I'm currently developing a system to manage inventory at ...