VBA works fine if you want to create macros and automate various things for your spreadsheets, but the problem is that the end user want / demand full-blown applications layered over their spreadsheets. The last thing I worked on was a CRUD -interface where the user could read and write data from their spreadsheet, to a azure DB.
It wasn't difficult, but at its core, I had to do it because the end users didn't feel like using some other interface - they really didn't want to leave their excel spreadsheet.
I might be mistaken but wasn't VBA brought into Excel as a familiar element from the VB world?
It is true though that some of the more purer or more initial concepts of VB likely live on in the VBA subsets of Excel.
And Access.