Give the VBA IDE a major overhaul finally
It's been over 20 years since the VBA IDE was created in its present form. MS has since created a number of modern and efficient development environments. Even if the VBA environment has long been referred to as outdated: it is simply the everyday reality for the majority of professional Office developers (especially all serious Access developers). I can not imagine that it lacks capacity to MS to bring the VBA IDE into a more contemporary form.
To insist that it would not be worthwhile to invest in an improved IDE, is roughly as if an automaker refuses any further developments in the wheels for 20 years, with the note that they would someday replace all wheels by air cushions.
I am thinking about things like "real" IntelliSense (comparable to that in current Visual Studio languages), extensive auto code completion, syntax checks that support the coder and do not hinder him/her, a much better integrated help system, refactoring tools, etc..
In other words: Not a newly decorated IDE, but simply an up-to-date developement tool like those in modern IDEs (Visual Studio, Eclipse, NetBeans, IntelliJ IDEA etc.). I do believe that this would not be "old wine in new bottles" but a valuable "productivity tool" for all Office developers.
Sorry for the earlier post – yes, we are excited about the early preview of Office Scripts, but we do realize there are many investments in VBA, and VBA has much broader scope and set of capabilities across applications. We want to thank everyone for their comments and votes on this thread. This is not the first time we’ve received this sort of request. We’ve also heard this feedback on the Excel UserVoice forum. You can read our full response at https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/8843113-bring-vba-into-the-modern-world.
We’ll summarize the key points here.
VBA will still continue to be supported in Office, and as we add new features in the Windows desktop versions of Office, we will add object model APIs for those features. You can find more details about feature improvements here: https://aka.ms/odevblog-vba.
Again, we appreciate the developer passion around VBA, and we’ll continue supporting VBA.
Office Extensibility Team
D.L. Owen commented
VBA is not dead.
You know what is dead? Many "new" replacement technologies Microsoft encouraged us to use instead. Anyone else waste time learning Lightswitch, Access Web Apps, PowerApps, Store add-ins, etc? Adoption was not great and in some cases the whole solution got deprecated. These things will never replace the macros and add-ins and Access applications people depend on daily to run the world. Millions of users deserve better than what Microsoft if offering. We can't keep pretending the VBE isn't a critical application in the 2019 enterprise.
It needs updating.
Rubberduck is great. And it's free. My vote is not particularly to get microsoft to upgrade the VBE but to allow people to use what editors they want to use "integrated" into the VBE so that copy/paste back and forth isn't necessary.
@Bill S - whining or otherwise, stating "learn to code" doesn't, in fact, encourage anyone to so do. I mean, apply that to being an artist. I realize a pencil isn't broken and it's dead simple to whip up a drawing, but does that really justify shunning people for insisting on raising the bar and going to a wacom since that's pretty much the norm - egads man, learn to freakin' draw and take your plebeian stench with you!
Over time, iterations of Office have brought more capability to the apps overall, so it makes absolutely no sense why there wouldn't be improvements on the IDE. It could be as simple as replacing it with VS Code or patching in to VS Code.
Too often i hear people, usually long time coders, say "there is nothing wrong with it" and while that's true - that doesn't mean it couldn't be better.
Bill S commented
While the IDE could use improvements rendering it competitive to a lot of other IDE's, I find a lot of comments here in nothing but a bunch of whining, because it is still easier and faster to whip up an Access Application than any other. How much intellisensing does one really need... Learn to Code!
QUACK QUACK commented
This is what the VBA Rubberduck project is all about. They should be sponsored by Microsoft as an official plugin. I would love to see it accepted and integrated.
Jim Conrad commented
Could VBA be connected to "Visual Studio Code" tool? Maybe a keyboard shortcut would take the existing code and open it in VSC, then return it to VBA when complete?
I spend 5-8 hours per day in the VBE, meaning I spend 8-10 hours per day wishing I could write VBA in VS!
Rodger Beard commented
Most of all, I would like to see a migration path from MS Access using SQL Server to VB 6. Starting with some sort of integration of MS Access into Visual Studio.
But within the current VBA UI, how about style sheets to apply color coloring, auto indenting, etc. according to customizable rules? Redgate does this very well with their SSMS addin SQL Prompt.
How about applying above to those super ugly, almost impossible to read SQL statements that display when you click RecordSource or RowSource in a form's properties or the SQL view of saved queries?
When I want to debug anything complex,especially queries I've developed with the Design UI but need to debug in a SQL syntax window, the first thing I do is copy the source into NotePad++. Then clean it up so it's actually readable. Of course when I save my easy to read code back Microsoft usually does what it does, and the formatting gone.
Lately I've been saving my queries in text files until I know whatever I've working on actually works right in all conditions.
I've been a developer a long, LONG time and can't believe this is still necessary.
VBA is awesome! It enables an application Power User to extend & enhance the functionality of the application with a skill set that is above a Power User & not yet a full programmer. Or, should I say full-time programmer? I am that sort of Power User. My "day job" is managing the manufacturing business that I own. We work hard at maximizing the OOTB capabilities of Office apps & SharePoint, but OOTB capabilities don't provide all the functionality that we need. So, my "second job" is to extend the capabilities using VBA. Our business is too small to afford staff or contract programmers.
It is so frustrating developing any type of code in the VBA IDE. This environment has essentially gone unchanged in over 20 years. Workarounds we did then, are still required now. If this is truly a dead language as Microsoft insists, why are so many companies still using it?
VBA is easy to learn and powerful even in its current form. Just imagine how powerful it would be if it supported inheritance and refactoring. I voted 3 times!
Svet Dimov commented
This is a very valid suggestion and I am not sure when and who declared VBA and all its underlying MS Office to be outdated when all investment banks use Microsoft from analyst to managing director and these are the entities that actually have the moneys to pay for quality, professional rapid/tactical VBA application development if it weren’t for all the noise of all recent technologies and languages. And more often than not the fancy, robust, strategic, multimillion dollar systems have a button to export to Excel. No matter what R and Python developers say, VBA with Access and Excel will dominate the analytics environment simply because it is the backbone of banks - and they are the ones providing and backing financing from a 200 credit card loan to a multi-billion dollar merger.
The current MS Forms controls with the refreshed color schemes provide an excellent environment for designer grade GUIs.
Refreshing the IDE would be welcome by all VBA enthusiasts and professionals.
Brian NZ commented
Got my Vote!
Or perhaps as an alternative a way to edit integrated VBA Projects from Visual Studio?
Anders Ebro (TheSmileyCoder) commented
Considering how many people must be spending a huge part of their workday in the Office VBE, I don't understand why there are no development effort in this.
Juan Soto, Access MVP commented
To all of you reading this post, your view is essential to getting a new IDE experience, vote today and leave a comment on why a new IDE will improve productivity, enhance the user experience and foster increased office development. The Microsoft of today is a data driven company and if we can all lend our voice to this idea it has a great chance of becoming a reality. Vote and promote it today!
VB6 Programming and VBA Programming commented
Microsoft could do this and merge the VB6 programming language and IDE with an updated VBA IDE...
Mark Burns commented
I am casting a vote for this even though I already Know that Microsoft has announced that they have NO INTENTION of doing any significant changes or improvements to VBA or its IDE.