View Single Post
 
Old 01-06-2021, 04:14 AM
LQuinn LQuinn is offline Windows 10 Office 2019
Novice
 
Join Date: Jan 2021
Location: Western Australia
Posts: 20
LQuinn is on a distinguished road
Default best practices for message handling between subroutines?

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
Reply With Quote