TextBox_Enter() Only Fires Once

Hello, I have stared at this piece of code too long and can't figure out what the problem is. I have two TextBoxes called fileNumberTextBox & appaFileNameTextBox and both get initialized with text when my UserForm is activated. For some reason, the fileNumberTextBox_Enter() sub procedure only fires once.

I click in the text box, the text disappears as it should, I don't change the text, I click out of the text box and the text repopulates as it should, I then click back in the texbox but the text does not disappear again. However, appaFileNameTextBox_Enter() fires as many times as necessary. Can anyone see an error in the below code? Thank you all in advance for your assistance.

Edit: I have figured out why fileNumberTextBox only fires once. fileNumberTextBox & appaFileNameTextBox are in different frames on my UserForm. Any ideas on how to use the code below with multiple textboxes in different frames?

Please Login or Register  to view this content.

Is it actually not firing, or is the If statement being evaluated false, making it look like nothing's happening? If the latter, can you determine why it evaluates false?

Can you post an example workbook that mirrors the issue? I don't see anything after a quick glance in the code, but would like to troubleshoot

I just created a test workbook and only kept the two textboxes and relevant code and it works as it should. I'm going to have to keep messing with it and see what I can come up with. I just don't see anything in the rest of my code that would cause the issue.

Thanks sanram & walruseggman for your help and debugging ideas.