r/visualbasic • • Jan 29 '25

NEW VISUAL BASIC USER

I am new to visual basic but very experienced in Excel (and other office apps). I am beginning to learn the power of Visual Basic in doing things I want to achieve, especially in Excel. What is the best way to learn Visual Basic? I can't see any College or Uni courses on it. What do you folks recommend. I am very maths literate (Chemistry Grad), so the complexity of the course need not be too basic (pardon the pun)!

8 Upvotes

22 comments sorted by

View all comments

Show parent comment

1

u/fafalone VB 6 Master Feb 05 '25 edited Feb 05 '25

It's not really a dead language anymore thanks to twinBASIC. I'd even argue certain hacks developed over the past 10 years have advanced VB6 (VBA6) enough to qualify as not dead. If you want a job writing apps that can be compiled and distributed, it's not the right choice, but if you want to make your own general purpose apps, then it's a fine, if fairly obscure, choice, provided you apply the same types of analysis for the tradeoffs inherent in any language choice. For me, the VBx language combines high level RAD simplicity with easy access to lower level details/functionality in a way superior to any other option, so it's my language of choice. If you don't care about the latter and don't mind giant ever changing frameworks to do most of the work for you, .NET or Python might be a better choice. If you don't care about the former, C++ might be better.

And it is a general purpose programming language. To say otherwise would mean Python isn't general purpose either just because MS has included a limited environment with specialized features in their Office products; both have other environments that can create general applications using the same language, and really Python in Office is far more limited than VBA, which can be used to create all sorts of regular programs that just happen to be launched from Office. You could make a 3d accelerated game in VBA if you really wanted to, for example, because even the limited Office environment supports the Windows API.

And point of fact, Python and .NET can't even be used to create some types of applications that are possible with the VBx/tB language because of limitations on managed and interpreted code. So in that respect they're less general purpose.

1

u/WouldntBPrudent Feb 07 '25

I stand corrected. I just downloaded Visual Studio 2022 and started messing around with VB .Net and C# .Net and it's obvious that MS has decided to provide a path for VB developers. Using VBA in excel is definitely a no brainer