WinVBA - an IDE for Visual Basic for Applications
WinVBA is a replacement IDE (Integrated Development Environment) for Visual Basic for Applications (VBA).
It is designed to provide a more modern and user-friendly interface for VBA development.
Disclamer
This product is NOT affiliated with Microsoft Corporation in any way.
Do NOT contact them for any issues related to this product.
Products
WinVBA
The main product, a modern IDE for VBA development.
WinVBA Add-in
An Office Add-in that allows you to open the WinVBA IDE from within Excel.
In addition this will add WinVBA to the context menu when right clicking on a sheet tab or button.
Features
This is a list of some of the features that are currently available in WinVBA:
- Editor:
- Tabbed interface
- Syntax highlighting
- Code auto completion
- Code navigation:
- View Sub/Functions in treeview
- View variables in treeview
- View references in treeview
Form designer:
- Currently not available, under development.
Source control:
- You can easily export the project or individual modules to disk as text files or ZIP archive.
Limitations
- Currently the product only works with Excel.
- In the future the product will be expanded to work with other Office applications
- In FormControls there is no custom Assign Macro option (right click on button to assign macro)
- Forms are not supported yet (working on it)
- Only one workbook can be opened at a time
- Many buttons and options don't work yet
- Debugging is not supported yet
- Immediate Window works but has limitations and known bugs
- Many known bugs and stability issues
- Speed and performance can be improved
- Themes are not saved yet thus you will have to set your theme every time you start the application
Requirements
- To use this product you need to have Microsoft Office installed on your computer and have a valid Office license.
- Windows 11 (it may work on Windows 10)