VBAssistant.ai
AI that writes your Excel VBA, right in the VB-editor
Start new thread

VBAssistant.ai - AI that writes your Excel VBA, right in the VB-editor

by•
VBAssistant.ai lives inside the Excel VBA editor - no more copy-pasting code to ChatGPT. Just describe what you want in plain language, and it writes, debugs, explains and optimizes macros and UserForms that fit your actual workbook. It knows your project's context, catches compile & runtime errors with fixes, generates docs, and ships with 100+ ready-made snippets. 100% private: your code runs on secured Azure servers, encrypted end-to-end, and is never used for AI training.

Add a comment

Replies

Best
Maker
📌
Hi everyone 👋 I'm Dirk - a consulting actuary who's spent 25+ years buried in Excel and VBA. Like a lot of people, I ended up constantly copy-pasting code between Excel and ChatGPT. It worked, but it was clunky, and I never felt great about pasting proprietary code into a public AI. So I built **VBAssistant.ai**: an AI assistant that lives inside the VBA editor. It knows the context of your project (and optionally your workbook structure), so the code it generates actually fits - not generic snippets. It writes and debugs macros and UserForms, explains code in plain English or German, optimizes for performance, and generates docs. Two things I cared about most: 🔒 Privacy: your code never touches public AI services. Everything runs on secured Azure servers, end-to-end encrypted, and is never used for training. ⚡ No context switching: no browser, no copy-paste — you stay in the editor. You can try it free - 10 AI requests, no credit card. All local features (code completion) stay free. It's also available in the Microsoft Store. Happy to answer any questions — feedback very welcome! 🙏

Lives right inside the VBA editor and actually picks up the context of my workbook, no more pasting snippets into a chat tab. The error-fix suggestions caught a dumb typo in my UserForm code that I kept missing.

Maker

 Thanks, that's exactly the itch I built it to scratch! The context-awareness is the part I'm proudest of - generic snippets never quite fit a real workbook. Glad it caught that UserForm typo; those are the ones that eat an afternoon. 🙏

Lives right in the VBA editor sounds genuinely useful, tired of bouncing between ChatGPT and Excel all day. One idea: let me save prompt templates for repetitive asks like "convert selection to an array" or "wrap in error handler" so I am not typing the same instructions over and over.

Maker

 Really good idea — saved prompt templates for recurring asks like "wrap in error handler" is something I've wanted myself. Adding it to the roadmap. Thanks for taking the time to think it through, that's genuinely helpful feedback.

Finally something that gets my actual workbook context instead of generic answers. The error catch and fix on the first try saved me an hour of digging through stack overflow.

Maker

 Appreciate it! The "generic answer" problem was my main frustration too - knowing the workbook structure makes all the difference. And there's more coming on exactly this front: beyond the Excel context (metadata), a future release will also feed structural information from your existing VBA project into the AI request, so the results fit your codebase even more precisely. Happy it already saved you the Stack Overflow rabbit hole! 🙂

Living right in the VBA editor sounds like exactly what I needed back when I was maintaining a monster workbook. One thing I'd love: a way to pin a few "house style" rules (like naming conventions or always wrap in error handlers) so every generated snippet matches my team's existing code without me having to rewrite it each time.

honestly the fact that it runs inside the VBA editor itself is genius, no more bouncing between tabs and losing track of what you were doing. love that it catches the actual errors in your sheet too instead of guessing blindly.

Living right inside the VBA editor sounds so much better than my current ChatGPT tab-switching ritual. One thing that would seal the deal for me: let it watch me run the macro and auto-log which lines threw errors, so I can ask "why did this fail" with the exact runtime context attached instead of pasting error messages manually.

Finally something that lives inside the VBA editor instead of another tab I forget to open. The context awareness actually caught a typo in my UserForm that I'd been squinting at for an hour.