Userform runs Initialize sub @ beginning of textbox AfterUpdate event w/out being called

Originally Posted by Norie

When you step through the code what line is triggering the Initialize event?

I placed the cursor at right before "Private Sub fPanelNumi_AfterUpdate()" and hit F8 and it immediately jumped over to the Initialize sub.

It has to load the form to run that sub

Originally Posted by xlnitwit

Hi,

What is the following line supposed to achieve

Please Login or Register  to view this content.

Nothing yet :-) As I said, that code is quite a mess right now, but stepping through with F8 shows me that it never even reaches the code in question. It instead hops to the Initialize sub which clears out the text I'd just entered into the textbox. After Initialize runs, my form pops up and I am then able to re-enter the text that I'd entered to begin with. The After_update sub then works correctly. So right now, here is what I think is happening:

1. enter text into textbox and hit enter
2. textbox starts the AfterUpdate event, and for some unknown reason calls the userform Initialize sub
3. the Initialize sub performs as intended and clears all data (including the text I just entered in step 1) from the form
4. I can then re-enter the text into the textbox and hit enter and the AfterUpdate sub performs correctly.

I'd like to include a better example file, but there is some proprietary stuff in the file and it is all linked together enough that it'll be difficult to pull out just the problematic area.

Originally Posted by xlnitwit

Was the form already loaded when you pressed f8? If it was not, the Initialize code should run because the form will be loaded automatically.

I should have thought of that. No, it wasn't already loaded. Please disregard my previous reply to you, I was typing while you were replying. So I entered the Breakpoint with F9 at the beginning of the sub as suggested by Norie. Stepping through after that, I discovered that the

Please Login or Register  to view this content.

you'd asked about earlier is the culprit. I had intended for that to be another conditional if statement, not a result of the else. There is code linked to those button clicks that initializes the form. It appears to be working now that I fixed that. Thanks all for the responses on what turns out to be a dumb mistake. Thanks also for the tips on the debugging tools, those will be very helpful.