Afraid I can’t help you directly in your quest, having so far avoided VBA with MSP. I assume you’ve trawled the VBA, Excel, etc forums for anything that you could adapt or build on? I will keep an eye on this in case anything useful surfaces.
Main reason for this reply: Thank you for the link to Reddick! My personal (undocumented) coding conventions have evolved over the years and in principle seem to match his, although minor detail like prefixes obviously differ. (Not sure about the section on comments tho’ – takes half the challenge out of debugging!
Coding standards, conventions, efficiency, and elegance have been an interest ever since I created the NEAT/3 coding standards for NCR Century systems in Oz. And that was far too many moons ago, back in the dim distant past when minimising executable size was almost as critical as having it work.
As distinct from the modern objective of the glitziest possible user interface with a gazillion functions, regardless of size or actual functionality