When comparing VBA vs Scala, the Slant community recommends Scala for most people. In the question“What is the best programming language to learn first?” Scala is ranked 27th while VBA is ranked 75th. The most important reason people chose Scala is:
The immutable values make it perfect for working with concurrency
Specs
Ranked in these QuestionsQuestion Ranking
Pros
Pro Immediate practical use.
VBA contains all of the same ingredients as more general-purpose programming language and can be immediately put to use in a professional capacity from inside Windows programs such as Excel.
Pro Immutable values
The immutable values make it perfect for working with concurrency
Pro Multiparadigm
Scala supports both Functional and Object Oriented styles of programming. Beginners can learn both paradigms without having to learn a new language, and experts can switch between the two according to what best suits their needs at the time.
Pro Type inference
Scala offers type inference, which, while giving the same safety as Java's type system, allows programmers to focus on the code itself, rather than on updating type annotations.
Pro Compiles to JVM bytecode
Aside from Java itself, Scala is by far the most popular of the many JVM languages. If you're developing for Android, or a similar JVM-only platform, or otherwise need out-of-the-box cross-platform compatibility, but the performance of a compiled language, Scala is the way to go.
Pro Very good online courses
On coursera you can find great introduction to Scala by Martin Odersky.
Pro Type inference leads to a simpler syntax
Pro Expressive functional programming abstraction for reusable and safe code
Cons
Con Limited Use
While it makes a lot of sense for someone wanting to get the most out of Microsoft Office and a handful of other applications, perhaps for the very practical reason of bolstering performance at work, it is restricted to use in those applications and is not suited for more general use most learners of programming are seeking.
Con Can be intimidating for beginners
Scala is an industrial language. It brings functional programming to the JVM, but not with a "start small and grow the language" perspective, but rather a very powerful language for professional programmers.
Con Way too complex for beginners
Even for seasoned programmers it's a difficult language.
Con Static type system inherits cruft from Java
The type system is too complicated yet still less powerful than Haskell's.