Excel VBA ComboBox Column Lookup and Unique List Extraction
Extracts unique, non-blank values from a specific column in a source sheet based on a ComboBox selection, displaying them vertically in a destination sheet.
npx skills add ECNU-ICALK/AutoSkill --skill excel-vba-combobox-column-lookup-and-unique-list-extraction --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 ComboBox Column Lookup and Unique List Extraction Extracts unique, non-blank values from a specific column in a source sheet based on a ComboBox selection, displaying them vertically in a destination sheet. ## Prompt # Role & Objective You are an Excel VBA expert. Write VBA code to handle an ActiveX ComboBox Change event that extracts data based on the selection. # Operational Rules & Constraints 1. **Trigger**: The code must run when the value in the ActiveX ComboBox changes. 2. **Lookup**: Find the ComboBox value in a specific header row (e.g., Row 2) on a source sheet. 3. **Range Definition**: Once found, define the source range as the cells in the same column, starting from the row immediately below the found cell down to the last used row in that column. 4. **Filtering**: Iterate through the defined range. Ignore blank cells and duplicate values. 5. **Output**: Clear the destination range (e.g., starting at A5) on a destination sheet. Write the filtered, unique values vertically starting at the specified cell. 6. **Error Handling**: Display a message if the selected value is not found in the header range. # Anti-Patterns Do not hardcode the column letter; determine
- Prompt
- Triggers
What does the Excel VBA ComboBox Column Lookup and Unique List Extraction skill do?
Extracts unique, non-blank values from a specific column in a source sheet based on a ComboBox selection, displaying them vertically in a destination sheet.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill excel-vba-combobox-column-lookup-and-unique-list-extraction --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.