How can vba be used to detect, as an event, a change in a string variable, so I can control the calling of some other vba procedures.
Posted on 2012-08-21
My problem is to to know how to programatically detect a change event in a string variable, here called strPhase.
As a user progresses through successive procedures ("myProc10" etc) in my vba project, the value of strPhase will successively reset through a succession of unique values ("callsupportproc_A", etc). For example:
program starts: strPhase set to "Begin"
vba procedure "myProc10" is activated: strPhase resets to "callsupportproc_A"
vba procedure "myProc19" is activated: strPhase resets to "callsupportproc_B"
vba procedure "myProc41" is activated: strPhase resets to "callsupportproc_C"
vba procedure "myProc53" is activated: strPhase resets to "End"
I think this will provide an extendable means of providing support material during the user experience.
I will apply this vba solution to a vba program in MS.Visio. I'm advertising my question under Excel Topic, as it is much more widely used, and the vba solution should essentially be transferable.
I am using class modules to detect changes in the values of UserForm controls, and wondered about using classes to detect these value changes in strPhase?