Excel VBA Column Validation Logic — independently scanned and version-tracked by SaferSkills.
SaferSkills independently audited Excel VBA Column Validation Logic (Agent Skill) and scored it 100/100 (green). The audit ran 55 deterministic rules across Security, Supply Chain, Maintenance, Transparency, and Community; it found 0 high-severity and 0 lower-severity findings. The full rule-by-rule trace and per-finding evidence are below. Free, methodology-open.
Findings & checks · 0 flagged
Every scanned point with the score it earned and what moved between them.
First recorded scan — no prior version to compare against.
The primary manifest — the file an agent reads to learn what this artifact does.
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').
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.
Target) is in Column J (Column index 10).Target.Value <> "").Target.Offset(0, -8) to reference Column B from Column J.InStr function to check for the substring (e.g., InStr(1, Target.Offset(0, -8).Value, "Request") = 0)..Find to search for specific values; rely on the Target object passed by the event..Find.Private Sub Worksheet_Change(ByVal Target As Range) code block.If condition combines the column check, non-blank check, and string exclusion check.~30 seconds. Free. No account. Every finding cites a rule and a line of evidence.