Array of user forms in excel ?

[shep6]

Is it possible to create an array of user forms in excel vba, like you can do in Viusal Basic?

I have a spreadsheet which contains 175 questions, these are to be split onto approx 20 user forms. I'm fine with creating 20 forms up front, but if the end user chooses to add, say, another 10 questions then these will need to be stored on another form.

As each of the forms are identical in layout, ideally I would like to create an array of forms based on how many questions there are.

thanks

 

[SkipVought]

Hi,

There are COLLECTIONS of Objects like arrays.

There is a Userforms Collection.



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[RobBroekhuis]

This sounds like the right kind of problem for on-the-fly generation of userforms, rather than using pre-canned userforms. Not something I've had much experience with, mind you - but you can have just a single userform in the project, and add/change controls to the userform, etc, all using code. Might that work for you? We can help if you need some direction.


Rob