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
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern identity platform for B2B SaaS
  • SaaSHub - Software Alternatives and Reviews
  • 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:

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  • 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