Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi folks,
I'm using VBA to create a "Wizard" in Excel. The Wizard is simply a collection of UserForms. In the first Form, the user is asked to supply the for names for a group of items. They do this by typing the names in to a Text Box, one at a time. For example, the first name is typed, the user presses an ADD button, and the Text Box's current value is written to an Array element. The Text Box is cleared, the user types another name, this is added to the next Array element, and so on..... When finished, the user clicks a NEXT button to advance to the next Form in the Wizard. In this Form, I'd like to present (in a combo- box) a list of all the elements in the Array. This gives the user a chance to review their entries, and make corrections if necessary. And here is my question....... How can I make the Array from Form1 visible to Form2? Kind regards, Jason Paris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA passing information between differnt User Forms | Excel Programming | |||
Passing a Forms Control to Function | Excel Programming | |||
passing variables between 2 forms | Excel Programming | |||
Passing variables between forms | Excel Programming | |||
User Forms - passing data between them | Excel Programming |