vba - does a boolean variable need to be reset after sub execution?

[devofish]

This may be a dumb question, but just as the question states - I have an argument that prevents the user from using Excel commands forcing the user to use vba cmds to save and/or close. I know a Close will obviously reset everything, but does the variable need to be reset after a Save or does the variable reset after exiting the routine?

 

[crazydragon84]

variable resets at end of the sub, UNLESS the variable is a public variable and you are running the sub as a subroutine. if you run a macro and after everything finishes running it will reset.

 

[RoryA]

A macro is a subroutine.

 

[crazydragon84]

1. Is the variable a public variable
2. are you calling the subroutine multiple times in the main sub
3. are you using the same variable in the main sub

if the answer to 1 is yes and either 2 or 3 is yes, then you should reset it, but otherwise, it think you are ok.

 

[devofish]

Thank you both! That helps my understanding.

Yes, the variable is public. The variable is set with a command button within the userform. When the userform is unloaded, would that constitute a reset?

 

[crazydragon84]

Yes if the unloading of the userform is the last step. No, if after it closes the user form, it continues to run other macros. aka it will reset once ALL routine is done running.