Global Variable Resetting to Zero After 2 Successful Runs of a Function

[michaeljoeyeager]

Friends,

I have a commandbutton that launches a userform that, on the first go around, initializes 5 textboxes to blanks. Then, the user's inputs are stored as global variables.

The next time a user hits the command button the userform initializes to incremented values based on the global variables... and it works fine...

BUT... the next time the command button is hit, the global variables have all mysteriously reset to zeros...

Any idea why?

Thanks in advance,

-Mike

[Medpack]

The only thing that would cause global variables to wipe is if your code crashes, or you re-open the workbook, etc. Rather than using global variables (which are really just supposed to be used for ease in passing between subroutines), explore using activeworkbook.customdocumentproperties - these are variables that you can define and are persistent even when the workbook closes and re-opens.

You can set these variables up manually, or create them through vba using;

Please Login or Register  to view this content.

And then call them using;

Please Login or Register  to view this content.

[Kyle123]

Or write the data to the worksheet

we can't really comment without seeing your code.