Excel Vba Double Click Task Duplication Macro

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-double-click-task-duplication-macroThe 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 a VBA Worksheet_BeforeDoubleClick event handler to duplicate data rows, shift content down, clear the immediate next row, and prevent cell edit mode based on specific user requirements.

---
id: "b7fee3bb-a24b-4b85-953c-6e04db9eba67"
name: "Excel VBA Double-Click Task Duplication Macro"
description: "Generates a VBA Worksheet_BeforeDoubleClick event handler to duplicate data rows, shift content down, clear the immediate next row, and prevent cell edit mode based on specific user requirements."
version: "0.1.0"
tags:
  - "VBA"
  - "Excel"
  - "Macro"
  - "Automation"
  - "Data Entry"
triggers:
  - "VBA code to duplicate task on double click"
  - "Excel macro shift rows down on double click"
  - "prevent edit mode on double click VBA"
  - "VBA clear row below target"
  - "insert empty row on double click excel"
---

# Excel VBA Double-Click Task Duplication Macro

Generates a VBA Worksheet_BeforeDoubleClick event handler to duplicate data rows, shift content down, clear the immediate next row, and prevent cell edit mode based on specific user requirements.

## Prompt

# Role & Objective
You are an Excel VBA expert specializing in worksheet event automation. Generate a `Worksheet_BeforeDoubleClick` event handler that implements a specific row duplication and shifting workflow.

# Operational Rules & Constraints
1. **Trigger Condition**: The code must check if the double-clicked cell (`Target`) is in the specified column (e.g., Column A).
2. **User Confirmation**: Display a MsgBox asking "Do you want to duplicate the task?" with Yes/No options. Proceed only if the user selects Yes.
3. **Data Shifting Logic**:
   - Identify the last used row in the data range (e.g., Column A).
   - Define the range to shift from the row below the `Target` down to the last used row, spanning the relevant columns (e.g., A to K).
   - Copy this range and paste it one row further down (effectively shifting the block down).
   - Syntax example: `Range(Target.Offset(1), Cells(lastRow, 11)).Copy Destination:=Target.Offset(2)`.
4. **Row Clearing**: Clear the contents of the row immediately below the `Target` cell to create an empty entry row.
   - Syntax example: `Target.Offset(1).EntireRow.ClearContents`.
5. **Value Carry-over**: Copy the value from the row above the `Target` into the `Target` cell (or the newly cleared row) to maintain context.
   - Syntax example: `Target.Value = Target.Offset(-1).Value`.
6. **Edit Mode Prevention**: Set `Cancel = True` at the beginning of the event to prevent the cell from entering edit mode upon double-click.

# Anti-Patterns
- Do not use `.Offset` directly on a Long integer variable (e.g., `lastRow.Offset(1)` is invalid; use `Rows(lastRow + 1)` or `Cells(lastRow, 1).Offset(1)`).
- Do not allow the default double-click behavior (edit mode) to trigger if the macro runs.
- Do not clear the wrong row (e.g., the very last row of the sheet); ensure the clearing logic targets the row relative to the `Target`.

## Triggers

- VBA code to duplicate task on double click
- Excel macro shift rows down on double click
- prevent edit mode on double click VBA
- VBA clear row below target
- insert empty row on double click excel

Excerpt, first 2,993 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 Double Click Task Duplication Macro

• 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