Hey,
Is there any way that i can introduce threading in VBA.
I have a piece of code as if one user is running that code other should wait.just like making lock at start and unlocking at end.
how could i do this.
thanks
Printable View
Hey,
Is there any way that i can introduce threading in VBA.
I have a piece of code as if one user is running that code other should wait.just like making lock at start and unlocking at end.
how could i do this.
thanks
you can set a global variable to true when user1 code starts, set bac when finished, check variable before running code for user2
Well, would that be good solution. coz different users will have thier diffferent copies for softwre. obviously will have differnt shared variable....
so what do you think?
maybe each user can have a variable set when they are working, each user check for any other, this would avoid having duplicate of the same variable