I created a fluent unit testing framework in VBA

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

Our great sponsors
  • talent.io - Download talent.io’s Tech Salary Report
  • SonarLint - Clean code begins in your IDE with SonarLint
  • Scout APM - Truly a developer’s best friend
  • Fluent-VBA

    A fluent unit testing framework 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:

  • talent.io

    Download talent.io’s Tech Salary Report. Median salaries, most in-demand technologies, state of the remote work... all you need to know your worth on the market by tech recruitment platform talent.io

  • 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