[sokoloff]

My frustration with VBA is that it didn’t seem very well documented.

If I could record a macro that was “close” and examine it, the ecosystem was very productive. Once I wanted to go beyond that, it seemed like there was an undocumented chasm to cross.

[Pasorrijer]

This has gotten a lot better with the internet.

Almost everything in VBA can be found with a simple Google search, and Microsoft's technical documentation online has gotten very good.

[kgwgk]

In the dark offline ages there were also those things called "books" :-)

https://www.oreilly.com/library/view/vb-vba/1565923588/

[sokoloff]

It wasn’t the VB part of VBA that wasn’t well documented, but rather the “for A” part that was spotty. The application automation model wasn’t as thoroughly documented as most of Microsoft’s stuff. This was well after the Internet was seriously prevalent.

Things like destroying [iff present] and recreating Excel charts from scratch, including generating all the series labels, shapes, etc., updating elements in a word doc from an excel sheet, generating on-slide progress indicators in PowerPoint.

[kgwgk]

That’s true. But the ability to record macros, as you mentioned, and the object browser alleviate the problem at least in part.