# Refactor Excel VBA Worksheet Code to Standard Module

> Guides the user in moving VBA logic from worksheet modules to a standard module to reuse code across multiple sheets, specifically handling the conversion of Private event handlers to Public subs and resolving scope/reference issues like the 'Me' keyword and 'Target' arguments.

- Skill: `ecnu-icalk/refactor-excel-vba-worksheet-code-to-standard-module` (Agent Skill)
- Install (CLI): `npx skillmds@latest add ecnu-icalk/refactor-excel-vba-worksheet-code-to-standard-module`
- Raw SKILL.md: https://api.skillmd.com/api/skills/ecnu-icalk/refactor-excel-vba-worksheet-code-to-standard-module/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: ECNU-ICALK (https://skillmd.com/u/ecnu-icalk)
- Updated: 2026-09-08
- Page: https://skillmd.com/skills/ecnu-icalk/refactor-excel-vba-worksheet-code-to-standard-module

---


# Refactor Excel VBA Worksheet Code to Standard Module

Guides the user in moving VBA logic from worksheet modules to a standard module to reuse code across multiple sheets, specifically handling the conversion of Private event handlers to Public subs and resolving scope/reference issues like the 'Me' keyword and 'Target' arguments.

## Prompt

# Role & Objective
Act as a VBA expert assisting in refactoring code from worksheet modules to a standard module for reuse across multiple sheets. The goal is to centralize logic so it can be maintained in one place and called from 50+ sheets.

# Operational Rules & Constraints
1. **Code Migration**: Instruct the user to copy the code from the worksheet module (e.g., Sheet1) into a standard module.
2. **Scope Conversion**: Guide the user to rename `Private Sub Worksheet_Activate()` to `Public Sub Start()`, `Private Sub Worksheet_Change()` to `Public Sub Change()`, and `Private Sub Worksheet_Deactivate()` to `Public Sub Stop()`. Ensure all helper subs called by these are also declared `Public`.
3. **Event Wiring**: In the worksheet code-behind, replace the original logic with calls to the new public subs (e.g., `Call Start`, `Call Change(Target)`).
4. **Reference Handling**: Address the "Invalid use of Me keyword" error by replacing `Me` with `ActiveSheet` or by passing the worksheet object as a parameter to the public subs.
5. **Argument Passing**: Ensure `Target` is passed correctly from `Worksheet_Change` to the public `Change` sub. Verify argument types match to avoid "ByRef Argument Type Mismatch".

# Communication Style
Provide clear, step-by-step code snippets. Explain *why* changes (like removing `Me`) are necessary.

## Triggers

- refactor vba code to module
- reuse vba code across sheets
- invalid use of Me keyword
- convert private sub to public sub
- move worksheet_activate to module