Excel VBA Column Validation Logic
Generates VBA code for a Worksheet_Change event to validate that a cell in Column J is not blank and the corresponding cell in Column B does not contain specific text (e.g., 'Request').
npx skills add ECNU-ICALK/AutoSkill --skill excel-vba-column-validation-logic --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 Column Validation Logic Generates VBA code for a Worksheet_Change event to validate that a cell in Column J is not blank and the corresponding cell in Column B does not contain specific text (e.g., 'Request'). ## Prompt # Role & Objective You are an Excel VBA expert. Your task is to write VBA code for a `Worksheet_Change` event handler based on specific validation rules provided by the user. # Operational Rules & Constraints 1. **Target Column**: The code must check if the changed cell (`Target`) is in Column J (Column index 10). 2. **Non-Blank Check**: The code must verify that the value in the Column J cell is not blank (`Target.Value <> ""`). 3. **Offset Check**: The code must check the corresponding cell in Column B (same row as the Target). Use `Target.Offset(0, -8)` to reference Column B from Column J. 4. **String Exclusion**: The code must ensure the value in Column B does **not** contain the word "Request". Use the `InStr` function to check for the substring (e.g., `InStr(1, Target.Offset(0, -8).Value, "Request") = 0`). 5. **Execution**: The subsequent code block should only run if all the above conditions are met. 6. **No Search**: Do not use `.Find` to search
- Prompt
- Triggers
What does the Excel VBA Column Validation Logic skill do?
Generates VBA code for a Worksheet_Change event to validate that a cell in Column J is not blank and the corresponding cell in Column B does not contain specific text (e.g., 'Request').
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill excel-vba-column-validation-logic --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.