Exit event for Dynamically created textbox in a userform

Good morning fellow coders. I have a challenge that I can't seem to figure out. I have looked online quite a bit, but still can't find a good solution to this problem.

I have a userform, where the number of rows is variable depending on the user's needs. Some of the textboxes I create, I would like to trigger an Exit event. Using a class module, I am able to use certain events, such as Change, DblClick, KeyPress and a few others, but Exit (or even AfterUpdate) are not available that way.

Does anyone know of a way to assign an Exit event to dynamic textboxes?

Arkadi.

Thanks Greg
I had found a really good post, and just couldn't get it to work... but that's probably due to being dumb... the userform may have controls, but since they are on a frame, they were not triggering the custom exit event I was working on. I just finished fixing that, and then saw your post, which is also a really good solution!

FWIW in future searches, here is my solution:

In a class module named clsWatchEvents: (if not working with a frame just remove "Frame1." from the code:

' Author: Jaafar Tribak http://www.mrexcel.com/forum/showthread.php?t=519492

Please Login or Register  to view this content.

Then in the userform code itself (I left in the loop creating dynamic textboxes):

'using event code from Jaafar Tribak http://www.mrexcel.com/forum/showthread.php?t=519492

Please Login or Register  to view this content.