Excel vba
Is a variable, such as global variables, and his life cycle after the program is running is destroyed? Want to save only in the exterior-interior curing?
I can destroy the variables stored in excel when there has been open?

My question is like this, I have a data table, there are some data, I want to processing of the data, and then in the variable, which is initialized
Then as the user click operation, such as trigger events, I want to call at any time the data
But I finished initialization function, all global variables (the local variable is) is destroyed, no content, I how to use...
I now can not initialize, as the user operation each time data to calculate the data in the table again, repeatability is very big, or after the initialization, the information stored in a list

Do you have any idea? thank you