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)