Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-06-2021, 04:14 AM
LQuinn LQuinn is offline best practices for message handling between subroutines? Windows 10 best practices for message handling between subroutines? Office 2019
Novice
best practices for message handling between subroutines?
 
Join Date: Jan 2021
Posts: 2
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
  #2  
Old 01-06-2021, 12:49 PM
eduzs eduzs is online now best practices for message handling between subroutines? Windows 10 best practices for message handling between subroutines? Office 2019
Competent Performer
 
Join Date: May 2017
Posts: 237
eduzs is on a distinguished road
Default

If you mean "passing status messages" as passing variables values, I imagine two possibilities, maybe:
Pass variables as arguments on a sub or a function.
Declare variables as Public (within project) or Private (within module).
__________________
Backup your original file before doing any modification.
Reply With Quote
  #3  
Old 01-06-2021, 04:58 PM
LQuinn LQuinn is offline best practices for message handling between subroutines? Windows 10 best practices for message handling between subroutines? Office 2019
Novice
best practices for message handling between subroutines?
 
Join Date: Jan 2021
Posts: 2
LQuinn is on a distinguished road
Default

Quote:
Originally Posted by eduzs View Post
If you mean "passing status messages" as passing variables values, I imagine two possibilities, maybe:
Pass variables as arguments on a sub or a function.
Declare variables as Public (within project) or Private (within module).
Thanks, I've tried playing around with that but have asked here because I think there must be a better way
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Handling message box prompts robert bristow Word VBA 2 07-10-2016 10:41 AM
best practices for message handling between subroutines? Images in Documents best practices liamnacuac Drawing and Graphics 1 03-29-2016 04:11 PM
best practices for message handling between subroutines? PivotTable best Practices lnicely@nvcc.edu Excel 1 07-13-2015 08:03 AM
Floor maps and best practices healthpointe Visio 0 07-10-2012 10:45 AM
Copying tables between Word documents best practices? dylane Word Tables 0 12-18-2008 12:21 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 05:41 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft