Change event for controls added

[nhoj]

Hello,

I have been building dynamic entry forms via method shown below.

Please Login or Register  to view this content.

I am curious if there is a way to add a change event to a newly added control within a running userform? I'd like to be able to have the user enter info on this newly added "temp" textbox that would then do a search afterupdate.

Thanks!

[Andy Pope]

You can use a class object that has a control object withevents. Note not all events are available.

useform code

Please Login or Register  to view this content.

class CCtlEvt code

Please Login or Register  to view this content.

The userform has a button that will add a control when clicked.
Changed text is displayed in immediate window and the userforms caption.


It's can sometimes simpler to add controls at design time and then make them visible and enabled at run time.

[nhoj]

Awesome thank you! Something new to learn

Definitely agree, and have historically used visible true/false for this, but for this project, the control qty and & dynamics makes this path more viable.

The reality is I'd love to embed a spreadsheet but it appears that reference library has been obsolete for a while.

Thanks again!

[nhoj]

One follow up now that I'm applying this great solution. In my case, I'll be making textbox groups with one primary box that I want the change event on...click the command button and a group of 5 boxes appear, with the first of that column being the box I want a change event.

Please Login or Register  to view this content.

Above I added a name thinking maybe I can set multiple boxes to the same mCtlEvt? Clearly not working but maybe there is a way that will? The idea is the user may make anywhere from 1 to 20+ groups of 5 so I could make enough discretely named class modules, but would prefer a more elegant solution.

Thinking maybe the class module can see if an object ends in "_1" then the change event will be triggered?

Thanks!

[nhoj]

For more clarity...currently it's only working for the last "Set" vs. ideal where any of the 3 "event" textboxes would change the parent name on change

Screenshot 2023-02-01 152418.jpg