Other Office applications are supported — no longer Excel only.
Fixed in 0.4.0
v0.4.0
New: debugging, multiple documents and the rest of Office
Write VBA in an editor from this decade
WinVBA is a replacement IDE for Visual Basic for Applications. Tabbed editing, syntax highlighting, code completion, real debugging and a project you can finally keep in source control.
Free download · Windows 11 · Requires Microsoft Office
WinVBA — Test_Workbook.xlsm
- Host applications
- 5 Office apps
- Version
- v0.4.0
- Platform
- Windows 11
- Price today
- Free
What's new in 0.4.0
Four of the biggest gaps just closed
These were all on the known-limitations list until this release. They aren't any more.
Several documents can be open at the same time.
Fixed in 0.4.0Debugging works: breakpoints, stepping and watches.
Fixed in 0.4.0Your theme and settings are saved between sessions.
Fixed in 0.4.0
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.
Editor
A code editor that feels like it belongs in this decade.
- Tabbed interface
- Syntax highlighting
- Code auto completion
- Light and dark themes
- Your theme and settings are remembered
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
Debugging
Stop the code where it goes wrong and look at what it is doing.
- Breakpoints
- Step through code
- Watches
- Immediate Window
Source control
Get your VBA out of the document 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 the document you already have open.
- Ribbon toolbar button
- Sheet tab context menu entry
- Button / shape context menu entry
- Several documents open at once
Form designer
Visual UserForm editing.
- Form designer Planned
WinVBA Add-in
Open the IDE from inside Office
The Office Add-in ships in the same download. Install it once and WinVBA is a click away from the document you already have open — no hunting through menus.
- A toolbar button that launches WinVBA for the active document.
- 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 document
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.
WinVBA — Project export
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.
A supported host
WinVBA opens VBA projects from Excel, Word, PowerPoint, Access and Publisher.
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 your own project today
The development build is free, includes the Office Add-in, and comes with a test workbook to play with.