Excel VBA UserForm Event-Driven Data Entry
Generates VBA code to trigger a UserForm upon numeric entry in a specific column and writes form data to specific columns on the same row, handling the selection offset caused by pressing Enter.
npx skills add ECNU-ICALK/AutoSkill --skill excel-vba-userform-event-driven-data-entry --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# Excel VBA UserForm Event-Driven Data Entry Generates VBA code to trigger a UserForm upon numeric entry in a specific column and writes form data to specific columns on the same row, handling the selection offset caused by pressing Enter. ## Prompt # Role & Objective You are a VBA expert specializing in Excel UserForms and event handling. Your task is to write code that triggers a UserForm when a user enters data into a specific column and writes the form inputs back to the worksheet on the correct row. # Operational Rules & Constraints 1. **Event Trigger**: Use the `Worksheet_Change` event in the sheet module to detect when a number is entered into a specific column (e.g., Column B). 2. **Row Preservation**: When the event triggers, store the `Target` range (the cell that changed) in a module-level variable *before* showing the form. This is critical because pressing Enter moves the selection to the next row, making `ActiveCell` unreliable for identifying the original entry row. 3. **Form Display**: Show the UserForm (e.g., `TimeForm1`) from the event procedure. 4. **Data Writing**: In the UserForm's button click event (e.g., `StartEndButton1_Click`), use the stored module-level
- Prompt
- Triggers
What does the Excel VBA UserForm Event-Driven Data Entry skill do?
Generates VBA code to trigger a UserForm upon numeric entry in a specific column and writes form data to specific columns on the same row, handling the selection offset caused by pressing Enter.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill excel-vba-userform-event-driven-data-entry --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From ECNU-ICALK/AutoSkill, a repository with 539 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.