What? OK, it is an OLDER platform. But apart from not having parameterized constructors (which it inherits from COM, of no fault of its own) I don't get the complaint. VBA is great, like all things, for the initiated. (Try writing a significant system in the WordPerfect 5.1 macro language!) To make it more robust, I built an error control system in VBA itself that allows discriminated error logging, all integrates into the language, and handles even recursive functions. Keeps the call stack, etc., and has purred away along with the main programming it supports in an Excel-based end-of-day system at several retail locations for years now. I show up once a year, look at the log, and generally just delete it. VBA is martial arts. I built a little column picker that lets the user create several different views of a spreadsheet and pick the desired view, or use it as a basis for a custom view on the spot. All just one form that plugs right in to any spreadsheet or XLAM. And a little programming will let you lock down spreadsheets, remove gridlines, etc., so they look like big windows forms, all automatically. Where else do you get juicy windows forms that have the ability to do math like that! Wrote a serialized inventory spreadsheet that took direct input from inventory guns, for cellular phones. Get a call they needed it for cellular identification modules...had it out that afternoon, all in a turn-key system. It just takes having a handful of tools that you put together into your XLAM. The only things I'm hateful about are messing with charting from 2003 to 2007, before which I had interactive zoomable mathematical charts, etc., all in VBA itself, and after which it crawled to a stop, and the Ribbon UI, which is painful and silly in its implementation, even if the end result is pretty nice (and when your clients see their special little tab just for them, they think you must really be a wizard). If you want any tools, visit Chip Pearson's website. Want the error system (which implements as a singleton offering several additions to your XLAM) or column picker, just let me know. I've got a sad github page up, but haven't really done it justice yet.
JonShops -- Fun really begins with the words, "So what in the World do I do now?"