This product was not featured by Product Hunt yet. It will not be visible on their landing page and won't be ranked (cannot win product of the day regardless of upvotes).
VBAssistant.ai
AI that writes your Excel VBA, right in the VB-editor
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.
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! 🙏
A few of you have suggested ways to make the generated code match your own setup better - pinnable "house style" rules (naming conventions, always wrapping in error handlers), saved prompt templates, and attaching runtime error context automatically. These all point in the same direction, and it's exactly where I want to take the tool: results that fit your codebase, not just generic VBA. Genuinely useful input - thank you all. 🙏
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.
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.
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 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.
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.
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.
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.
About VBAssistant.ai on Product Hunt
“AI that writes your Excel VBA, right in the VB-editor”
VBAssistant.ai was submitted on Product Hunt and earned 14 upvotes and 12 comments, placing #51 on the daily leaderboard. 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.
VBAssistant.ai was featured in Productivity (656.2k followers), Developer Tools (515.9k followers) and Artificial Intelligence (473.7k followers) on Product Hunt. Together, these topics include over 329.5k products, making this a competitive space to launch in.
Who hunted VBAssistant.ai?
VBAssistant.ai was hunted by Dirk Nötzel. A “hunter” on Product Hunt is the community member who submits a product to the platform — uploading the images, the link, and tagging the makers behind it. Hunters typically write the first comment explaining why a product is worth attention, and their followers are notified the moment they post. Around 79% of featured launches on Product Hunt are self-hunted by their makers, but a well-known hunter still acts as a signal of quality to the rest of the community. See the full all-time top hunters leaderboard to discover who is shaping the Product Hunt ecosystem.
Want to see how VBAssistant.ai stacked up against nearby launches in real time? Check out the live launch dashboard for upvote speed charts, proximity comparisons, and more analytics.
Dirk Nötzel