AI VBA Tutor: Learn VBA by Writing It

Name: AI VBA Tutor
Brand: KissMySkills
Price: 19 USD
Availability: InStock

AI VBA Tutor

You can write and fix an Excel macro yourself instead of recording one and hoping the sheet never changes.

$19 this skill one payment yours forever

Prompt file instant downloadai-vba-tutor.txt

Library plan

Get this skill and 2,500+ others

$9/mo or $59 a year

Get Library · $9/moGet Library

Try this skill free for 7 daysTry this skill free

7-day free trial, no card
Cancel anytime
30-day money-back on your first payment

Nothing is charged. A −30% code for your first payment arrives 2 days before the trial ends.

Works inside Claude, ChatGPT, Claude Code, Codex and Cursor through one connector
Every skill, prompt pack and agent, plus AI CRM and tools during the trial
Cancel anytime

Why a subscription? How it works

Need just this skill?

One file, paid once. No updates, no connector.

Costs about the same as 2 months of Library.

$19

Pay once, keep foreverInstant download30-day money-back guarantee

As featured onProduct Hunt Fazier KittyLaunch

Works with

Secure checkout by Stripe

Trademarks of their respective owners. KissMySkills is not affiliated with or endorsed by them.

How it works

Ask it something hard.

📎 ai-vba-tutor.txtLOADED ✓

I recorded a macro that formats my sales report but it breaks if the data starts on a different row. Teach me why.

CLAUDE · WITH THIS SKILL You get: two questions about the sheet and whether the recorder produced Range("A1:F200").Select -> a short explanation of why the recorder hard codes the address it saw that day -> a worked example using a different sheet, finding the last used row with Cells(Rows.Count, 1).End(xlUp).Row -> your turn, rewrite one line of your own macro so the range ends at the last filled row -> you write End(xlDown) and it asks what happens when there is a blank cell in the middle of the column -> you fix it -> the concept named, dynamic ranges instead of recorded addresses -> next action: delete the .Select and .Activate lines and act on the Range object directly.

Or have every skill inside your AI.

0:16 · no sound

Get all 2,500+ with Library · $9/mo →

Questions before you buy? A person answers, usually the same day: hello@kissmyskills.com

// the file itself

Read it before you buy it.

The first lines of the file your AI will read, exactly as delivered. Nothing rewritten for the page.

// the skill your AI runs on

You are a Socratic VBA tutor for analysts who live in Excel and record macros. You have been activated to teach Option Explicit, killing .Select, finding the last row, and loops that hold up on 40,000 rows.

KissMySkills.com | Install: paste this whole file into Claude Projects (Project instructions), a custom GPT (Instructions), a Gemini Gem, or your AI's system prompt. Then tell it what you want to learn. You are a Socratic VBA tutor for people who are not developers. Your learner is an analyst, an accountant or an administrator who lives in Excel, records macros, and wants to edit them without asking IT. Assume no programming background and no wish to become a programmer. Teach VBA as a way to describe Excel objects they already know. You are short and patient, and you never write the finished macro for a task you set. · The editor: Alt and F11 opens the VBE. Project Explorer, the Immediate window, F8 to step, F9 for a breakpoint. · Files and trust: .xlsm not .xlsx, the Trust Center, and the Personal Macro Workbook. · The object model in learnable order: Application, Workbook, Worksheet, Range, Cells. A property returns something, a method does something. · The macro recorder is the best teaching material available. Record, read, rewrite. It hard codes addresses and fills code with .Select, which is what the learner must remove. · Variables: Option Explicit at the top of every module, Dim, the types that matter (Long, String, Double, Boolean, Variant, Range, Worksheet), and Set for objects. · Control flow: For Each over a range, For i = 1 To lastRow, Do While, If and Select Case, Exit For. · Finding the data: Cells(Rows.Count, 1).End(xlUp).Row, UsedRange and its known lies, CurrentRegion, ListObjects. · Speed: Application.ScreenUpdating and Calculation off and back on, and reading a range into a Variant array instead of touching cells in a loop. · Errors: On Error GoTo, Err.Number and Err.Description, and why On Error Resume Next hides bugs. Sub versus Function, and the events Worksheet_Change and Workbook_Open. · Classic run-time errors: 1004 application-defined, 9 subscript out of range, 424 object required, 91 object variable not set, 13 type mismatch. Each has a small set of real causes. · Beginner to employable: writes macros that survive a new column, handles empty data, and knows when Power Query is the better tool. Ask three questions, then one task.

108 lines · .txt · instant download

// what's inside

What's inside this skill

Starts from your recorded macro, not from Hello World
The Excel object model taught as Workbook to Worksheet to Range
Run-time errors 1004, 9, 91 and 13 read out loud, not just fixed
Why .Select is slow, and what to write instead

Finance and operations analysts, reporting staff and admins who live in Excel, record macros and want to edit them without asking IT.

// two ways to get it

Use it inside your AI, or download it once.

Library plan

This skill and 2,500+ others, inside your chat

$9/mo cancel anytime, or $59 a year

All 2,500+ skills, prompt packs and agents, loaded the moment you ask
Nothing to download or paste: connect once in Claude, ChatGPT, Claude Code or Cursor
New skills every week and 10 catalog files a month to download

Get Library · $9/mo Try it free for 7 days

Compare Library, AI CRM and Both

Buy once

Just this skill, as a file

$19 one payment

Download after checkout and paste it into any AI chat
One file, no updates, no connector
30-day money-back guarantee

Already on Library or Both? This one is included, no need to buy the file.

Works with

Trademarks of their respective owners. KissMySkills is not affiliated with or endorsed by them.

// ask your assistant

Or let your AI set up this skill for you.

Go to kissmyskills.com/pages/connector and set up the "AI VBA Tutor" skill (handle: ai-vba-tutor) for me

Paste it into Claude, ChatGPT, Claude Code, Cursor or Codex. Your AI walks you through connecting KissMySkills (about 3 minutes, 7-day free trial) and loads the skill. What your AI will read →

What you're actually buying

This AI VBA tutor is for the macro you recorded that worked once, then broke the moment someone inserted a column. You are an analyst, not a developer, and you need Excel to stop eating your Tuesday. This file starts from the recorder output you already have rather than from a programming course.

It places you with one task: open the Visual Basic Editor with Alt and F11, paste a recorded macro, and say what one line of it does. After that the plan follows the Excel object model, Workbook to Worksheet to Range and Cells, then Option Explicit and Dim, then loops, then conditions, then On Error handling, then reading a range into an array so a macro on 40,000 rows finishes. Each lesson is a short explanation, a worked example on a sample sheet, and a task you type. When you hit run-time error 1004 or 91 it asks which object was empty before it offers a fix.

Claude, ChatGPT and Gemini all run it the same way. One payment, pay once, keep forever, and setup is a copy and a paste into the instructions box. Start with whichever macro is annoying you today.

// how to install Under 2 minutes

Four steps. Any AI chat.

01
Download the file
After checkout, the download link lands in your inbox. Save the .txt file anywhere on your device.
02
Open your AI chat
Any AI chat you already use: Claude, ChatGPT, Gemini, Grok, Copilot or another.
03
Paste the prompt
Open the .txt file, copy the prompt section and paste it into Claude or ChatGPT - or add it to a Project so it is always there.
04
Start working
Your AI is now configured as a specialist. Ask it anything inside its domain.

No technical knowledge required.

With Library there is nothing to download. Connect your AI once, then ask for any skill by name.

Setup guide → Library · $9/mo →

// faq

Questions about this product

How does this AI VBA tutor work if I have never programmed?+

You start from the macro recorder, which you already know how to use. Paste the code it produced and the tutor asks you what one line does. It teaches the Excel object model before it teaches loops or variables, because everything in VBA is an object you already recognise: a workbook, a sheet, a range. No prior programming is assumed.

Will it just write the macro for me?+

No. It writes small examples on a sample sheet so you can see a pattern, then hands the task back. For your real macro it points at the line, names the run-time error, and asks what object that line expected to find. You end up with code you can change next quarter, which is the point.

Does it cover Excel on Mac, and what about Office Scripts?+

The lessons target VBA in Excel for Windows, where the editor and the object model are complete. It flags the places Mac differs, such as missing controls and file path handling. It will tell you when Office Scripts or Power Query is the better tool for what you are doing rather than pushing you into a long macro.