Editor
A code editor that feels like it belongs in this decade.
- Tabbed interface
- Syntax highlighting
- Code auto completion
- Light and dark themes
Dev build
In active development — free while it lasts
Write VBA in an editor from this decade
WinVBA is a replacement IDE for Visual Basic for Applications. Tabbed editing, syntax highlighting, code completion and a project you can finally keep in source control.
Free download · Windows 11 · Requires Microsoft Office
- Host application
- Microsoft Excel
- Platform
- Windows 11
- Themes
- Light & dark
- Price today
- Free
Features
Everything the built-in editor never got
WinVBA sits alongside Office and gives your macro code the tooling ordinary languages have had for years. Here is what works today — and what is still coming.
Code navigation
Find your way around a project without scrolling through modules.
- View Sub/Functions in treeview
- View variables in treeview
- View references in treeview
Source control
Get your VBA out of the workbook and into files you can diff.
- Export the whole project to disk as text
- Export individual modules
- Export to a ZIP archive
Office integration
Open the IDE straight from Excel, where you already are.
- Ribbon toolbar button
- Sheet tab context menu entry
- Button / shape context menu entry
- Support for other Office applications Planned
Form designer
Visual UserForm editing.
- Form designer Planned
Debugging
Stepping, breakpoints and inspection.
- Immediate Window Partial
- Breakpoints and stepping Planned
WinVBA Add-in
Open the IDE from inside Excel
The Office Add-in ships in the same download. Install it once and WinVBA is a click away from the workbook you already have open — no hunting through menus.
- A toolbar button that launches WinVBA for the active workbook.
- An entry in the context menu when you right-click a sheet tab.
- The same entry when you right-click a button or shape.
Source control
Get your code out of the workbook
VBA lives locked inside a binary file, which makes diffs, reviews and history effectively impossible. WinVBA exports the whole project — or a single module — as plain text you can commit like any other code.
- Export an entire project to a folder of text files.
- Export individual modules when that is all you need.
- Or bundle the lot into a ZIP archive for backup.
Requirements
What you need to run it
Microsoft Office
You need Microsoft Office installed on your computer, with a valid Office license. WinVBA works alongside Office — it does not replace it.
Windows 11
Windows 11 is the supported platform. It may also work on Windows 10, but that is not actively tested.
Excel
Excel is the only host application supported at the moment. Other Office applications are on the roadmap.
Not affiliated with Microsoft
This product is not affiliated with Microsoft Corporation in any way. Please do not contact them about anything related to WinVBA — get in touch with us instead.
Try it on a workbook today
The development build is free, includes the Excel Add-in, and comes with a test workbook to play with.