S
sjdolding
Apologies for starting a new thread, however I could not see a means
of adding to the existing discussion
http://groups.google.com/group/micr...st&q=array+after+code+execution&rnum=1&hl=en#
Unlike the previous poster I wish to retain the values of my arrays
after code execution (in order to repopulate previously captured data
on a user form if the user wishes to change their mind after initial
submission). Running Excel 2003.
However, wherever i declare my array be it globally in a module or
ThisWorkbook it always clears itself after code execution. To be
honest this is the behaviour I expected and I was surprised with Tom
Olgivy's answer that a global variable will retain its value for the
life of the workbook. I was expecting to have to add something extra
to the declaration.
Any help greatly appreciated.
Simon
of adding to the existing discussion
http://groups.google.com/group/micr...st&q=array+after+code+execution&rnum=1&hl=en#
Unlike the previous poster I wish to retain the values of my arrays
after code execution (in order to repopulate previously captured data
on a user form if the user wishes to change their mind after initial
submission). Running Excel 2003.
However, wherever i declare my array be it globally in a module or
ThisWorkbook it always clears itself after code execution. To be
honest this is the behaviour I expected and I was surprised with Tom
Olgivy's answer that a global variable will retain its value for the
life of the workbook. I was expecting to have to add something extra
to the declaration.
Any help greatly appreciated.
Simon