Visual Basic for Applications (VBA) was long the undisputed king of the spreadsheet, but its dominance is finally waning.