View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mcambrose mcambrose is offline
external usenet poster
 
Posts: 27
Default Question What determines if publlic variable content is destroyed

I have some code that creates an array public variable and then saves some
values to this variable. When I end this subroutine, I can look at the
immediate window and check the contents and it is available. I have another
subroutine that uses the same code, but it also has a userform in it. When
the second routine finishes, the variable contents are destroyed. Is there
something about userforms that messes with variables.