Excel Vba Column Validation Logic

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-column-validation-logicThe 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 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').

---
id: "825953ef-3857-445a-90d2-d2a977df2624"
name: "Excel VBA Column Validation Logic"
description: "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')."
version: "0.1.0"
tags:
  - "excel"
  - "vba"
  - "validation"
  - "worksheet_change"
  - "conditional_logic"
triggers:
  - "vba check column j and b"
  - "excel vba worksheet change validation"
  - "check if column j is not blank and column b does not contain request"
  - "vba code to validate two columns on change"
---

# 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 for specific values; rely on the `Target` object passed by the event.

# Anti-Patterns
- Do not loop through the entire column unless explicitly asked.
- Do not search for specific values in Column J using `.Find`.
- Do not assume the user wants to check a specific fixed cell address (like J2) unless specified; default to the column-based logic.

# Interaction Workflow
1. Receive the user's request for VBA validation logic.
2. Generate the `Private Sub Worksheet_Change(ByVal Target As Range)` code block.
3. Ensure the `If` condition combines the column check, non-blank check, and string exclusion check.

## Triggers

- vba check column j and b
- excel vba worksheet change validation
- check if column j is not blank and column b does not contain request
- vba code to validate two columns on change

Excerpt, first 2,624 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 Column Validation Logic

• 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