# rubberduck-vba/Rubberduck

Every programmer needs a rubberduck. COM add-in for the VBA & VB6 IDE (VBE).

Repository: https://github.com/rubberduck-vba/Rubberduck
Canonical: https://ross.abutalabs.com/products/rubberduck
Homepage: https://rubberduckvba.com
Language: C#
License: GPL-3.0
License Family: copyleft
Topics: vba, c-sharp, ide, metaprogramming, static-code-analysis, refactorings, unit-testing, vba-ide, indentation, parsing, dot-net, com, com-interop, win32, ms-office, linter, addin, parsing-expression-grammar, vb6, hacktoberfest
Archived: true
Last push: 2025-06-25T16:38:32+00:00

## Health v2 (maintenance only)
Score: 10/100 (v2, computed 2026-09-03T02:39:23.370411+00:00)
- activity 28, release rhythm 40, longevity 100
- inputs: {"age_days": 4329, "days_push": 434, "days_rel": 434, "gap_med": 2.5, "n_releases_24m": 15}
- flags: prerelease_only, archived
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 2129, forks 328 (observed 2026-08-28T04:06:17.073195+00:00)

## What it is
Rubberduck is a COM add-in that modernizes the legacy Visual Basic Editor (VBE) used for VBA and VB6 development. It provides static code analysis, refactorings, enhanced code navigation, and unit testing capabilities within the VBE.

## Use cases
- lint and statically analyze VBA code in Excel or Access
- refactor VBA procedures and rename identifiers safely
- run unit tests for VBA macros
- navigate and explore large VBA projects with a code explorer
- add modern IDE tooling to the Visual Basic Editor
- indent and format VBA code consistently

## When to choose
- you maintain or develop VBA/VB6 code in Microsoft Office applications
- you want static analysis, refactoring, and unit testing inside the VBE
- you need better navigation and inspection for legacy VB projects

## When to avoid
- you work in modern .NET or other languages outside the VBE
- you need a cross-platform tool - it is Windows-only via COM interop
- you cannot install COM add-ins due to locked-down Office environments

## Facets
- artifact type: plugin
- maturity: active
- function: linter, testing, parser, developer-tools, editor
- domain: developer-tools, text-editors, parsers
- platform: windows, dotnet, editor-plugin
- tags: vba, vb6, vbe-addin, com-interop, ms-office, code-inspection, refactoring-tools, parsing-expression-grammar, static-code-analysis, refactoring, automation

## Member repositories
- rubberduck-vba/Rubberduck (main) score 10

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:06:17.073195+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T02:52:25.659547+00:00, confidence not recorded.
  - readme: https://github.com/rubberduck-vba/Rubberduck (fetched 2026-08-28T04:06:17.073195+00:00, sha 233ea2367517)
  - homepage: https://rubberduckvba.com (fetched 2026-08-29T10:32:22.127757+00:00, sha 8f111bb3af03)
- Data as of 2026-08-30T08:39:29.467469+00:00.