Yep, I did a few VBA+Access apps in the mid-to-late 90s. VBA in Access 7/97 was kind of buggy, too, so there were some truly awful workarounds involved.
And speaking of HTML, there was also VBScript, which for me is inextricably linked to classic ASP.