I’m doing some Excel VBA work for $dayjob and got a few books to brush up on the tech involved:

• Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET
• Excel 2019 Power Programming with VBA