Testing Strategies for VBA Code: Ensuring Quality Like a Pro

Bring discipline to VBA with automated checks and repeatable tests.

---

Layering for testability

• Pure Functions for calculations
• Thin orchestration in Subs
• External effects behind interfaces (I/O, Outlook)

---

Unit-like tests

Create test procedures that assert expectations with Debug.Assert:

Sub Test_NetPrice()
    Debug.Assert Abs(NetPrice(119, 0.19) - 100) < 0.0001
End Sub

---

Tools & practices

• Rubberduck inspections
• Code reviews via Git diffs
• Static checks: Option Explicit, no Select/Activate