Variable life

  • Thread starter Thread starter morph
  • Start date Start date
M

morph

Hello. Please help me if you can.

If you "Dim" an array at module level, the contents of the
array survive after the code stops running.

For example, I can load up an array with one button click.
After that program stops, I can then change sheets (or
whatever) and click another button and do something with
the contents of that array in a completely separate
subroutine.

Is there a way to do this with a single element variable?
If so, could you supply me with the example code to do it?

Thanks in advance for your assistance.
 
Non-array variables are exactly the same, if declared at the module level.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top