|>>|| No. 7526
Well, I'm not going to tell you how to commit crime. But if you really do want to build and run mathematical simulations then VBA is certainly not the way to go. It's clumsy, and you'll be stuck doing anything beyond the rudimentary.
C++ is the go-to language for this sort of thing (in my experience, though I expect to start an argument) but as a novice you'd be better off studying Python. It has a more intuitive syntax for developing your own algorithms. Get to grips with the basics of the ubiquitous NumPy package. And try following guides like this hastily-googled one: