Adding up textbox values in multipage - page 1 is fine, page 2 stops

[Menohavename]

Hi there,

in a userform multipage, I need to create multiple textboxes and a label which sums them up in a "live" manner which means that as soon as a value is entered/changed in a textbox, the label value changes. This may happen on mutiple pages but depending on inputs, some multipage pages may not have these functionalities. I read some similar issues in this forum and using class modules, I managed to do that... almost. The problem is: If only one page has textboxes and the label, it works perfectly. As soon as a second page has the same functionality, it stops working. So my first thought went to the textbox naming but all textboxes have unique names and are called by them so I cannot spot the mistake. I hope you can help me with that.

Creation of textboxes (all within a for loop which goes through the multipage pages using i):

Please Login or Register  to view this content.

Creation of sum label:

Please Login or Register  to view this content.

Class module stuff (from this forum. I don't fully understand it but it does the job):

Please Login or Register  to view this content.

Within the class module:

Please Login or Register  to view this content.

AutoCalc:

Please Login or Register  to view this content.

I assume this is the essential code. Let me know if you need more. If required, I could try to attach a minimal example workbook but as the actual work is confidential, this would need a quite a bit of rework so I thought maybe this code is already enough to solve the issue.

Any help is much appreciated!

[mehmetcik]

This does the job without using a class module:

Please Login or Register  to view this content.

This is better:

Please Login or Register  to view this content.

[Menohavename]

Hi,

thank you for your reply. Your solution does not add up the scores "live" but only once the button is clicked, right? I need that live function though. I did not describe this detail in my original statement, I'll add it now.

[ArdusPetus]

Hi,

This does the job without using a class module:

If you quit using the class module, you will also loose the Change event processing! Don't do that!

Please post the integral contents of your Userform code. I don't see the loop that goes through the multipages.
Better : save your userform and post the resulting file.

Thanks,
--
LR

[Menohavename]

Better : save your userform and post the resulting file.

Great idea, thanks! Here it comes, together with the class module.

[mehmetcik]

Please Login or Register  to view this content.

[ArdusPetus]

Just before the end of the main loop (For i = 0 to numberOfFactors - 1, you have the folllowing code:

Please Login or Register  to view this content.

The first line initializes the collection, erasing its previous contents from previous pages. That is wrong. You should move that code outside of the loop, at the beginning of the Initialize Sub.

[Menohavename]

Please Login or Register  to view this content.

Theoretically yes, but the textboxes are generated dynamically and their number can vary between 1 and 100 so this doesn't work, unfortunately.

The first line initializes the collection, erasing its previous contents from previous pages. That is wrong. You should move that code outside of the loop, at the beginning of the Initialize Sub.

That makes sense, yes. Unfortunately, I changed it accordingly but the issue still remains.

I thought about the confidentiality issue again and I think it should be fine. Therefore, find the file attached. It would be fantastic if you could please have a look at it. The instruction to reproduce the issue is:
- Add an alternative of your choice
- Add a decision criterion to factor "Performance"
- Go to Weighting and you'll see that it works perfectly, both on the first multipage as well as on the performance multipage
- Close and add another criterion, to "Mass" for instance.
- Go to Weighting again and it doesn't work anymore.

What I figured out now is that now the sum is not calculated across all the textboxes on the same multipage but adds up all textboxes on all pages. On multipage Performance, this doesn't happen in a "live" manner while it does on multipage Mass. Now I'm totally confused.

Edit: Attachement removed because I don't want to have it to be available online anymore.

[Menohavename]

Any idea, ArdusPetus or anybody else?

[Menohavename]

That is wrong. You should move that code outside of the loop, at the beginning of the Initialize Sub.

I got it up and running now! I tried this again and somehow I guess I made a mistake the last time. Then there was a slight glitch in the sum function but I got that fixed, too. Thank you so much!