Menu
Is it possible to replace Excel's built-in VBA Editor or IDE with a modern one such as VS Code or VS Studio?
As a C# developer, I prefer the Visual Studio IDE. Excel's VBA Editor/IDE is very dated by comparison. It lacks the sophisticated features found in even the most basic IDEs, such as column selection, jump to references, and useful keyboard shortcuts. As an example, there's no keyboard shortcut for terminating a debugging session.
While it does support many useful features such as suggestions, syntax checking and syntax coloring, they don't work well. It still lacks anything like intellisense. The syntax checking is very obstructive and limited to the most obvious cases. The syntax coloring is limited to keywords and comments. It's autocompletion only works in limited scenarios.
831
What Will Replace VBA? Short answer: JavaScript. JavaScript is a language Microsoft has been heavily investing in as it moves to unify Office across all devices (PC, Mac, Browser, & Mobile).
Access. On the Database Tools tab, in the Macro group, click Visual Basic. In the Visual Basic Editor, on the Help menu, click Microsoft Visual Basic Help. In the Help window, click Access VBA Reference.
As of July 1, 2007, Microsoft no longer offers VBA distribution licenses to new customers. Microsoft intended to add . NET-based languages to the current version of VBA ever since the release of the .
It's a separate application but you can only use it with Excel. You need to have the developer tab on the ribbon to access it. You can also use the keyboard shortcut (Alt + F11). It also stores the macros that you recode with the macro recorder.
You might consider using VB.NET instead of VBA for your Excel development. Excel-DNA (which I develop) is an open source framework for integrating .NET in Excel, which tries to make the VBA to .NET conversion as easy as possible.
Then you can use any editor for the VB.NET (or C#) code, including the Visual Studio Express editions or SharpDevelop.
132
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
