View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Albert Albert is offline
external usenet poster
 
Posts: 203
Default Public variable Forgotten by VBA!

Really???
Darn!
Sorry to hear that!


"Jim Cone" wrote:



You are not alone.
I had to do a System Restore after uninstalling the @2010 Tech Preview.
--
Jim Cone
Portland, Oregon USA



"Albert"
wrote in message
...
Hello!
I have a strange issue today with my VBA procedures in several workbooks. I
use many public variables, declared in general purpose modules.

Everything had been working fine until yesterday. I used to have 3 versions
of Excel in my machine: 2003, 2007 and 2010 Tech Preview. Yesterday I
uninstalled 2010 and 2003.
For some odd reason, since then VBA is "forgetting" the value of my public
variables!
I changed the scope of the variables to Global and now it works again, but
this does not seem to be an appropiate solution to the problem...
Anyone have a clue as to why this is happening?
Thanks in advance,
Albert C.