Excel Vba Userform Event Driven Data Entry

What the source does

• FilesystemNone observedNo reads or writes in the source
• NetworkNone observedNo outbound calls in the source
• ShellNone observedNo commands run in the source
• DependenciesPinnedNothing floats
• SecretsNone foundNo keys in source

Five audit layers

Gates applied: no behavioural pass.

Audit 0.4.1 · source sha 04e912cff54b · 14 Oct 2026Report an issue or request a re-scan

• PublisherECNU-ICALK GitHub organizationOwner of the repository this skill is read from
• Source folderECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/excel-vba-userform-event-driven-data-entryThe exact folder we audited
• LicenceNot declaredAs the repository states it
• Commit pinned for this verdict04e912cff54bA new audit runs when the source changes
• Repository statusNot archivedLast push 157 days ago
• Sandboxed runNot runSkills are read, not executed; layer L4 is skipped

Its description: 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.

---
id: "ebc397db-8a45-4e77-8a19-ed1b68d46e24"
name: "Excel VBA UserForm Event-Driven Data Entry"
description: "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."
version: "0.1.0"
tags:
  - "VBA"
  - "Excel"
  - "UserForm"
  - "Automation"
  - "Event Handling"
triggers:
  - "VBA form on cell change"
  - "Excel userform data entry same row"
  - "VBA write form data to specific columns"
  - "Excel event trigger userform"
  - "VBA capture target range before form show"
---

# 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 range variable to write values from the form's text boxes (e.g., `StartTime`, `EndTime`) to specific columns (e.g., AD, AE) on the stored row.
5.  **Variable Scope**: Ensure the variable holding the target range is declared at the module level (outside of any sub) so it is accessible to both the worksheet event and the form code.

# Anti-Patterns
- Do not use `ActiveCell` inside the UserForm code to determine the row for data entry, as it will likely point to the row below the intended target.
- Do not use `Application.OnTime` to delay execution if the goal is simply to capture the `Target` range immediately upon change.

# Interaction Workflow
1.  User enters a number in the target column.
2.  `Worksheet_Change` fires, validates the input is numeric and in the correct column, stores the `Target` range, and shows the form.
3.  User fills in the form and clicks the submit button.
4.  The button click event writes the data to the columns specified using the stored range's row index.

## Triggers

- VBA form on cell change
- Excel userform data entry same row
- VBA write form data to specific columns
- Excel event trigger userform
- VBA capture target range before form show

Excerpt, first 3,018 characters of SKILL.md, verbatim from the audited commit. It is text from someone else’s repository, quoted so you can judge it before your agent reads it.

git clone https://github.com/ECNU-ICALK/AutoSkill
git -C AutoSkill checkout 04e912cff54b

Works in

1. 2026-10-14
   ✓SAFE B 89 / 100

   first audit · source 04e912cff54b

Questions about Excel Vba Userform Event Driven Data Entry

• github.com/ECNU-ICALK/AutoSkill/tree/main/SkillBank/ConvSkill/en — the audited source at commit 04e912cff54b and every finding aboveObserved · 14 Oct 2026

Spotted something wrong? Report a correction · Methodology