LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Passing an Array between Forms?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA passing information between differnt User Forms chfa Excel Programming 6 March 27th 07 11:58 AM
Passing a Forms Control to Function Pflugs Excel Programming 5 August 24th 06 10:34 PM
passing variables between 2 forms burl_rfc Excel Programming 3 April 14th 06 05:49 AM
Passing variables between forms Sami82[_8_] Excel Programming 7 October 8th 05 12:12 AM
User Forms - passing data between them mickiedevries Excel Programming 3 June 21st 04 08:59 PM


All times are GMT +1. The time now is 08:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"