Class module for userform textboxes

[Knoet]

I have

Please Login or Register  to view this content.

Please Login or Register  to view this content.

and so on for 40 textboxes
What would be the class module for 40 textboxes.

[dotchiejack]

Sorry, I was wrong,misunderstand the question.

[Andy Pope]

You need to post example file as your current code is not clear on how it is used.
On the surface it looks like you are multiplying the contents of a textbox by the contents of another textbox. But as you are doing this in the change event everytime you update the textbox it will trigger the change event again and carry on in a loop.

Your class would need to include 2 textbox objects.

[Knoet]

Hi Andy,
Thanks for responding.
I made a small example, but I have a whole list like this.
Please advice.

[Andy Pope]

Userform module

Please Login or Register  to view this content.

Class module, Class1

Please Login or Register  to view this content.

[Knoet]

Thank you Andy,great job.

[Knoet]

Hi, I have a next question.
What would be te cllas module solution if I want the total of the 3 TextBoxt textboxes.
Thanks to look into my problem.

[Andy Pope]

You could have added a public sub to the userform and used that.
But I have used another class object to centralise the callbacks to the userform.


Class module, CEventListener

Please Login or Register  to view this content.

revised Class1 module code

Please Login or Register  to view this content.

revised userform code

Please Login or Register  to view this content.

[Knoet]

Hi Andy,
Thank you for your reply.
I have a problem as we use comma's instead of dots, the calculatins are not correct. I tryed to replace the comma's by dots but i still have wrong calculations.
Any ideas?
Thanks

[Andy Pope]

If the issue is with numeric separators and decimal delimiter, then it would not have been working for you at the start.

I assume for you the number ten you would use comma for decimal 10,0 rather than the period I would expect with UK settings 10.0

What does the VAL function return for the test values? You will need to step through the code and check or use debug.print commands to write to the immediate window

[mjr veverka]

... I have a problem as we use comma's instead of dots, the calculatins are not correct. I tryed to replace the comma's by dots but i still have wrong calculations ...

How did you try to change it ?

Just use the 'Replace' function to achieve the desired effect, e.g.:

Please Login or Register  to view this content.