Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
public variables | Excel Discussion (Misc queries) | |||
Public variables | Excel Discussion (Misc queries) | |||
Public Variables | Excel Discussion (Misc queries) | |||
Public Variables | Excel Programming | |||
Public Variables with UserForms | Excel Programming |