Hi all, I've spent a lot of time googling as well as searching here, hoping someone could point me in the right direction for best practices on message handling please?


More of a soft concept search rather than a specific search for which methods and properties are exposed by any particular item, so not getting much joy on search results

I develop VBA to process documents that have been handed around multiple different users, all with their own interpretation and styles, so I remediate, normalise and then standardise document content - all in modular subroutines

What I'm looking for is advice on how to handle passing status messages, so all the routines run and then upon completion I can present a single message that has content from each subroutine (if required)

Thanks in advance