I created a fluent unit testing framework in VBA

This page summarizes the projects mentioned and recommended in the original post on /r/vba

Our great sponsors
  • WorkOS - The modern identity platform for B2B SaaS
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • Onboard AI - ChatGPT with full context of any GitHub repo.
  • Fluent-VBA

    A fluent unit testing library for VBA

    You can check out my mTests.bas module to see the set of tests that I use to test the framework. These tests are located in the runMainTests sub. this sub runs three other subs: metaTests, positiveDocumentionTests and negativeDocumentationTests. metaTests are what the framework uses to tests iteself. Positive tests check that the API should return true when it should. And negative tests check that the API should not return false when it shouldn't. In addition to that, I have six example subs showing the different types of ways tests can be written.

  • stdVBA

    VBA Standard Library - A Collection of libraries to form a common standard layer for modern VBA applications.

    There're numerous unit testors out there already. I do find it interesting as to why many prefer this result.equalTo(3) compared to result = 3. My own is a single class and goes down the Test.Assert message, x=y route. As a result most of my tests look like:

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  • vba-test

    Add testing and TDD to VBA on Windows and Mac

    Yup, this framework is a bit different from traditional unit testing frameworks. In addition to the ones you mentioned, vba-test is another popular one. This framework is in the fluent style. It was inspired by Fluent Assertions in C#.

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts