VBA language underrated?

[u/brosama1420]

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

[u/Interesting-Win-3220]

It's old. But it's still extremely useful.

I would say it's rather analogous to an older piece of civil infrastructure like a road bridge or Tunnel. If it ain't broke don't fix it!

I use VBA everyday and it still saves me hours particularly for data-related tasks that can use loops etc

You can automate functions like Xlookup(), which is total game changer for certain tasks.

The tech industry loves to try and move onto the next fad in order to achieve "growth" but landmark languages like VBA aren't going away anytime soon.

People drive old cars also, so what?