Userform textbox event that fires after I exit the textbox

I need a userform textbox event that fires after I tab or click out of the textbox. Going by the list of options:Beforedragover, BeforeDroporPaste, Change, DblClick, DropButtonClick, Error, Keydown, Keypress, keyup, mousedown, mousemove, mouseup.

I can't figure out which one will do what I want. The change event happens instantaneously which doesn't work. I need to fire off the event when my focus leaves the textbox.

That wasn't on my list of choices but I will give it a try.

Is there some additional code that I will need in my class module to make it work? This is what I have so far:

Please Login or Register  to view this content.

It doesn't seem to be firing based on the code that I have there currently.

So I am out of luck? These are controls that are created at runtime so my understanding was that you had to create a class module and write all of the event procedures there. All of my other controls that are created at runtime are working. Is there a different event that is available that might be able to do the same thing?

P.S. The guidance you gave me on the issue with looping commandbutton events was spot on. It was because I was associating the command button with each instance of my class.

Originally Posted by romperstomper

Let's go back to the beginning for a moment then - why are you creating the textboxes at runtime?

Because I won't know ahead of time how many lines will need to be created by the user. They click on a commandbutton to add a new line. Attached is my workbook with some working code. Right now I am using the mouseover event to format the text in the text box. It works but I see it as a sloppy compromise.

That is actually a really good idea. I will have to explore that. It may make it easier for individuals that have multiple portfolios that need to be consolidated into one total return.