Borrowing it
Nothing to install: this file belongs to RenRMT/claude-code-vba-skills. Take a copy, put it at the same path in your own repository, and replace the rules that are about this project with yours.
curl -O https://raw.githubusercontent.com/RenRMT/claude-code-vba-skills/main/.claude/skills/vba-procedures-and-encapsulation/SKILL.mdgit clone --depth 1 https://github.com/RenRMT/claude-code-vba-skillsWrote this? Show the measurements
A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.
[](https://agentmods.dev/skills/renrmt/claude-code-vba-skills/vba-procedures-and-encapsulation)<a href="https://agentmods.dev/skills/renrmt/claude-code-vba-skills/vba-procedures-and-encapsulation"><img src="https://agentmods.dev/badge/skills/renrmt/claude-code-vba-skills/vba-procedures-and-encapsulation/github.svg" alt="Measured on agentmods" height="20"></a>Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.
<a href="https://agentmods.dev/skills/renrmt/claude-code-vba-skills/vba-procedures-and-encapsulation"><img src="https://agentmods.dev/badge/skills/renrmt/claude-code-vba-skills/vba-procedures-and-encapsulation.svg" alt="Reviewed on agentmods" width="80" height="20"></a>What it costs to keep this loaded
Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.
| Model | Per session | Once invoked |
|---|---|---|
| Fable 5.1 | $0.00022 | $0.00448 |
| Opus 5.5 | $0.00009 | $0.00179 |
| Sonnet 5.5 | $0.00004 | $0.00090 |
| Haiku 4.5 | $0.00002 | $0.00045 |
Grade A, and why
vba-procedures-and-encapsulation scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 2mo ago.
A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.
Nothing flagged
None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.
What it actually says
VBA Procedures, Scope & Encapsulation — Expanded Edition
Write small, intention‑revealing, testable, object‑oriented VBA.
Purpose
Reduce hidden coupling, enforce predictable behavior, and make logic testable by controlling scope and organizing code into well-designed procedures and classes.
Scope Rules
Prefer Small Local Scope
Public Sub ProcessData()
Dim ws As Worksheet
Set ws = ThisWorkbook.Worksheets("Data")
End Sub
Avoid module-level variables unless necessary.
When to Use Module-Level Private
- Shared helper state for 2–3 functions.
- Cached objects that are expensive to access.
Never Use Public Variables
Global state creates fragile, unpredictable code.
Encapsulation with Classes
Example: Class clsCustomer
Private mId As String
Private mBalance As Currency
Public Property Get Id() As String: Id = mId: End Property
Public Property Let Id(ByVal value As String)
If Len(value) = 0 Then Err.Raise 1001, , "Id cannot be empty"
mId = value
End Property
Clear Procedure Design
Guard Clauses
If ws Is Nothing Then Exit Sub
If Not IsValidData(arr) Then Exit Sub
Long Procedures → Pipeline
Public Sub RunWorkflow()
LoadData
ValidateData
TransformData
WriteOutput
End Sub
Do / Don't
Do
- Break complex logic into multiple functions.
- Document expectations and invariants.
- Use classes for domain concepts.
Don’t
- Allow 500‑line procedures.
- Mutate parameters accidentally via
ByRef.
Anti‑Patterns
BAD: Hidden shared state.
BAD: Classes with only public fields.
BAD: Procedures dependent on module-level scratch variables.
Acceptance Checklist
- All public state justified.
- No procedure longer than one screen.
- Domain logic encapsulated.
What this file has done since we first saw it
Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.
- 2mo ago First seen · 93 lines · 22 tokens per session scan A fcd1fcf12f7b
vba-procedures-and-encapsulation is a skill published in the GitHub repository RenRMT/claude-code-vba-skills (2 stars, last pushed 7mo ago), licensed MIT. It adds 22 tokens to every session and 448 once invoked, about $0.0001 per session on Opus 5.5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-31.
Other skills, from other repositories
erlang-otp-behaviors
Use when oTP behaviors including genserver for stateful processes, genstatem for state machines, supervisors for fault tolerance, genevent for event handling, and building robust, production-ready Erlang applications with proven patterns.
omh-rust
This is an OMH rust workflow skill, projected for Agent Skills hosts (Claude Code, Codex, Cursor, opencode, OpenClaw, pi).
axiom-concurrency
Use when writing ANY async code, actors, or threads in an Apple-platform app, or seeing ANY concurrency error. Covers Swift 6 concurrency, @MainActor, Sendable, data races, async/await patterns.
tdd
Guided test-driven development workflow for .NET 10 using xUnit v3, WebApplicationFactory, Testcontainers, and Verify snapshots. Follows the strict red-green-refactor cycle. Use when: "TDD", "test-driven", "let's TDD this", "red green refactor", "write the test first", or when building a feature with clear acceptance…
splitting-oversized-modules
Split an oversized Python module (a thousand-plus-line logic.py, models.py, api.py, or its test file) into a package of one module per concern, mechanically and provably without changing behavior. Use on a request to split / break up / decompose a god module or move functions out of one, once a human has agreed to…
precise
Online (incremental) covariance, correlation, and precision estimation in Python — the streaming complement to sklearn.covariance. Use when code needs a covariance/correlation matrix updated per observation, recomputes np.cov/np.corrcoef in a rolling loop, must judge or compare covariance estimates, or proposes a new…