View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey[_190_] ExcelMonkey[_190_] is offline
external usenet poster
 
Posts: 172
Default Public Variables

I have a file with 3 userforms and 1 module. In userfor1
I have declared a public variable:

Public SheetExcludeArray As Variant

The first part of this form calls userform2 which
populates the array. On userform2 I populate this array
and the Debug.Print tells me the values are present
within the procedcures that support useform2. When I am
finished with this form I Unload it and this takes me
back to userform1. When I complete the rest of userform1
my main routine is called. The main routine uses teh
values from the array I populated. However the values
are not longer present. Is this becuase I am unloading
the form?

Thanks