Why is my click event looping 4 times

[jerseyguy1996]

I have created a program to perform a calculation on data input into a userform. When I click on the "Calculate" button it is supposed to run the calculation and then show the user the result in a message box. When they click "ok" the message box should go away and just leave the form showing. For some reason, when I click on "ok" it loops back through the click event handler again and shows the message box with the result again. It does this 4 times before finally going away for good. Is there some easy reason why this might be happening?


The click event is handled within my class as a Public WithEvents object. The code is:

Please Login or Register  to view this content.

Calculatesub is here:

Please Login or Register  to view this content.

[romperstomper]

I can't see anything in the Calculatesub code, so I'd guess it has to do with how your class is related to the userform and its controls.

[jerseyguy1996]

That must be the problem. I am adding the control to every instance of the class that gets created.