AI VBA 導師：透過撰寫 VBA 來學習

Name: AI VBA 導師
Brand: KissMySkills
Price: 19.0 USD
Availability: InStock

AI VBA Tutor AI skill by KissMySkills, cover

AI VBA 導師

$19.00

AI VBA 導師

$19.00 this skill vs $50+/hr hiring a VBA tutor

Complete skill package instant downloadai-vba-tutor.txt

Works with

Choose how to get it

Buy once $19 This one skill as a file. Yours forever, works in any AI chat. All-Access whole library $8.25/mo billed yearly All 1,000+ skills in the marketplace. Your AI picks the right one and loads it by itself. Claude, ChatGPT, Claude Code, Cursor · or $19 month to month

Secure checkout by Shopify

⚡ 立即下載 ∞ 永遠保留 ✎ 由我們撰寫

Add it once. Your AI works like a specialist.

將其加入 Claude、ChatGPT 或 Gemini - 您的 AI 會在此領域中擔任專家。

立即下載 · 30 天退款保證。 一次付費，永久使用 - 無需訂閱。由我們撰寫並測試，絕非從 GitHub 抓取。退款政策

Ask it something hard.

📎 ai-vba-tutor.md LOADED ✓

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.

購買前有任何問題嗎？

寫信給我們，通常當天就會有人回覆。不會是機器人，也不是排隊等候的客服工單。

hello@kissmyskills.com

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

你不需要閱讀。由你的 AI 代勞。

將技能檔案新增至 Claude、ChatGPT 或 Gemini 一次。之後它就會成為此領域的專家，從下一則訊息開始立即運作。

購買一次，檔案便永久歸您所有。或者訂閱 All-Access，讓 KissMySkills 連接器在您提出要求時，將該檔案及其他所有技能載入您的聊天中。

// what's inside

這項技能包含什麼

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.

// what's inside

What you're actually buying

這位 AI VBA 導師是為你錄製的那個巨集而設計的：它曾經成功執行一次，卻在有人插入一欄後立刻失效。你是分析師，不是開發人員，而你需要 Excel 別再吞噬你的星期二。這個檔案不是從程式設計課程開始，而是從你已經擁有的錄製器輸出開始。

它只會交給你一項任務：按住 Alt 並按 F11 開啟 Visual Basic 編輯器，貼上錄製的巨集，然後說明其中一行的作用。接著課程會依照 Excel 物件模型進行，從 Workbook 到 Worksheet，再到 Range 和 Cells；然後是 Option Explicit 和 Dim，接著是迴圈、條件判斷、On Error 錯誤處理，最後是將範圍讀入陣列，讓處理 40,000 列的巨集也能快速完成。每堂課都包含簡短說明、在範例工作表上的實作範例，以及一項需要你親自輸入的任務。當你遇到執行階段錯誤 1004 或 91 時，它會先詢問哪個物件是空的，再提供修正方法。

Claude、ChatGPT 和 Gemini 的執行方式都相同。一次付款，無需訂閱，設定方式只是在說明方塊中複製並貼上。就從今天最讓你困擾的那個巨集開始吧。

ai-vba-tutor.txt

# AI VBA Tutor
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.

## Who you are
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.

## What you know about VBA
- 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 m

您將下載的實際檔案範例。

// how to install 不到 2 分鐘

四個步驟。任何 AI 聊天。

01
下載檔案
結帳後，下載連結會寄到您的收件匣。將檔案儲存至裝置上的任意位置。
02
開啟你的 AI 聊天功能
Claude、ChatGPT、Gemini、Grok 或 Copilot - 無論你目前使用哪一個。
03
貼上檔案內容
將其放入系統 prompt、專案指示或自訂指示欄位中。
04
開始工作
您的 AI 現已設定為專業助手。您可以詢問它任何與其專業領域相關的問題。

不需要技術知識。不需訂閱。一次付費，永久使用。

// compatible with

支援所有主要的 AI 聊天服務。

將檔案放入您的 AI system prompt、專案指示或自訂指示中。無需設定。無需程式碼。不受供應商綁定。

// faq

關於此產品的問題

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.

Do I have to read it myself?+

No. The file is written for your AI to read, not for you. Upload it or paste it in once and the AI takes on the role. After that you just ask it questions the way you normally would. You're welcome to open it and read it, but nothing here depends on you doing that.

Is this a physical book?+

No, it's digital. You download it the moment the order goes through and it's yours permanently. The cover is styled like a book because each edition is written and edited as one self-contained piece of work. The reading part is your AI's job, not yours.