Overview
VBA Mode is the Excel equivalent of Google Sheets' AppScript Mode. By default, SheetXAI's chatbot handles requests for you automatically. Switch to VBA Mode when you want SheetXAI to instead hand you a VBA macro that you install and run yourself — useful for:
- Formatting or logic beyond what Excel's built-in conditional formatting/data validation can do
- A reusable macro you want to keep, inspect, or edit
- An interactive button that runs a routine when clicked
How To Use It
Step 1: Switch to VBA Mode
In the SheetXAI Excel add-in, switch the chat mode to VBA.
Step 2: Describe what you want
Tell it in plain English what you want the macro to do, for example:
"Write a macro that formats the headers in dark blue with white text and applies alternating grey highlights to all other rows."
SheetXAI will generate the corresponding VBA code — and its reply will also walk you through what to do with it.
Step 3: Follow the instructions SheetXAI gives you
SheetXAI's reply tells you where to paste the code (the VBA editor — Developer → Visual Basic, or Alt+F11) and, if what you asked for needs it, how to wire it up from there — saving as a macro-enabled workbook, or assigning it to a button. Just follow those instructions as given; they're tailored to what you asked for.
Related Guides
- AppScript Mode: Build Custom Automations and Buttons in Google Sheets — the Google Sheets equivalent