Count UserForms in a collection of another VBA Project

[esbencito]

Hi all,

I'm adding multiple instances of a UserForm to a collection from my AddIn workbook

Please Login or Register  to view this content.

and then need to count these instances inside another workbook, which I am struggling to achieve. I am aware of below to get the number of forms in the same project.

Please Login or Register  to view this content.

but can this be done in another project too? Something like below?

Please Login or Register  to view this content.

[rorya]

Short answer: no. You'd need a function/method in the other workbook to return the value. Why is it useful, out of interest?

[esbencito]

I built two addins, one with general features, one specifically for certain workbooks. For the sake of maintenance I want to call a procedure from the ribbon of the specific addin, but have that procedure load the userform from the general addin, to avoid duplication of userforms. Now since I created multiple modeless instances of that userform to show multiple product images at the same time, I need to loop through the userform collection and change the position of each userform depending on it's index in order to display the images in a certain order on the screen. Does that make sense?

Please Login or Register  to view this content.

[rorya]

Then you'll need to add a function to the general add-in that returns the data you need, or one that simply does what you need directly. I don't really see much benefit in having two add-ins rather than just enabling/disabling some functionality based on which workbook is active.

[esbencito]

hmm... will have to use a function somehow then I guess. The reason for two addins is that there are multiple developers each working on different projects, so actually there will be around 6 addins in total that are only installed if the corresponding workbook is opened. Though, there will always be two addins installed at the same time as there's a default addin doing some "control work" and storing basic functions and userforms. This is the only way I can think of to keep us sane with all the maintenance and simultaneous development.