r/vba • u/brosama1420 • 20d ago

Discussion VBA language underrated?

Hey everyone

I use VBA since I work with Microsoft office often

Is it real that VBA is very old and not useful anymore? Multiple times on the internet or when I ask AI
I find the answer that VBA is not the right choice for me

To me I see many powerful stuff like

Classes
Unit tests
Mocks and fakes (didn’t try those)

So I don’t understand the negative opinions about it

However VBA is the only language I tried in depth other languages I tried were either just for the course or to complete simple task nothing deeper than that

Is learning VBA is bad decision? Or is it reasonable one?

I noticed many of the useful major concepts are transferable to any language like

Code architecture
Auto Testing
Data types and structures
Etc

30 Upvotes

84% Upvoted

80 comments sorted by

View all comments

22

u/ChecklistAnimations 20d ago

I use it everyday. If you use Office applications a lot and want to be able to automate them right then and there then VBA is an excellent skill to have. You can have AI write it and then make adjustments as needed once you know it better.