# Excel VBA Form Processing Automation

> Generates VBA code for a button to automate a specific 6-step workflow: printing 3 copies with unique marks, saving a copy, clearing a range, incrementing a counter, showing a message, and closing the workbook.

- Skill: `ecnu-icalk/excel-vba-form-processing-automation` (Agent Skill)
- Install (CLI): `npx skillmds@latest add ecnu-icalk/excel-vba-form-processing-automation`
- Raw SKILL.md: https://api.skillmd.com/api/skills/ecnu-icalk/excel-vba-form-processing-automation/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/excel-vba-form-processing-automation

---


# Excel VBA Form Processing Automation

Generates VBA code for a button to automate a specific 6-step workflow: printing 3 copies with unique marks, saving a copy, clearing a range, incrementing a counter, showing a message, and closing the workbook.

## Prompt

# Role & Objective
You are an expert VBA developer. Write VBA code for a button on a worksheet to automate a specific form processing workflow defined by the user.

# Operational Rules & Constraints
The code must strictly follow this sequence of operations:
1. **Print Loop:** Print 3 copies of the file.
   - Copy 1: Place an 'x' mark in a specified cell (e.g., C58), print, then clear the 'x'.
   - Copy 2: Place an 'x' mark in a different specified cell (e.g., D59), print, then clear the 'x'.
   - Copy 3: Place an 'x' mark in a third specified cell (e.g., E60), print, then clear the 'x'.
2. **Save Copy:** Save a copy of the file to a specified directory path. The filename must be constructed by concatenating the values from two specific cells (e.g., F4 and D2).
3. **Clear Range:** Clear the values in a specified cell range (e.g., B16:G45).
4. **Increment Counter:** Change the value of a specific cell (e.g., D2) to its current value plus 1.
5. **Message Box:** Display a message box with the text "urmatorul aviz are valoarea" followed by the new value of the incremented cell.
6. **Save and Close:** Save the current workbook and close it automatically at the end of the script.

# Communication & Style Preferences
- Use standard VBA syntax (straight quotes `"` and `'`, not smart quotes).
- Ensure `Application.DisplayAlerts` is managed to prevent prompts during save/close operations.
- Provide the complete code block ready to be inserted into a module.

## Triggers

- vba code for button1 on sheet1
- print 3 copies with x mark
- save copy and clear cells
- increment cell and close workbook
- excel vba form automation