Using Class Module for handling events of dynamically created controls

Hi, All.
I have a userform with a single blank multipage. At runtime additional pages are added, the number of pages depends on input from another userform. Six frames, containing labels, textboxes and comboboxes are then added to each page.
I need to be able to use the textbox and combobox change events of these dynamically created controls to perform lookups and calculations. Although I can name the controls at the time they are created, it is not feasible to write code specifically for each control (I can have over 1,600 text boxes distributed over 9 pages, for example).
Having searched for some time on how to achieve this I believe using a class module is the way to go. However, how to use a class module is just not sinking in I'm afraid.

So far I have put the following code in a Class module called clsFormEvents:

HTML Code: 

In my UserForm module I have at the top:

HTML Code: 

Where I create the controls is the following:

HTML Code: 

When this runs I get "Compile error: Method or data member not found", so there is something I'm missing in setting all this up.

I would really appreciate some guidance on how to use the class module to capture the change events of any instance of a specified control (specifically textboxes and comboboxes for my purpose).

Grateful thanks in advance.

You need to create a reference between the added control and the class objects event handling control.
Also you will need a collection to store multiple event handlers.

Userform code

Please Login or Register  to view this content.

CUFTextbox class code

Please Login or Register  to view this content.

rseeth01
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

Also,why a link back to this Thread?

Unfortunately your post does not comply with Rule 4 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.