I've searched for a solution to this, but can't find anything. There is an old thread I found where someone was having this same issue many years ago, so I thought I'd start a new one and maybe someone can explain this to me.
This only happens intermittently. Only sometimes, when I press tab or enter to go to the next textbox in my userform it will not work. When it malfunctions the tab key will just put spaces in the textbox, and the enter key will do nothing. It's like for some reason the TabKeyBehavior switches from false to true for no known reason. If I close out the userform and reopen it, it will begin working fine. I have no code that would change the tabkeybehavior, so I'm not sure what would be causing the malfunction. Any ideas on what could be causing this behavior?
This only happens intermittently. Only sometimes, when I press tab or enter to go to the next textbox in my userform it will not work. When it malfunctions the tab key will just put spaces in the textbox, and the enter key will do nothing. It's like for some reason the TabKeyBehavior switches from false to true for no known reason. If I close out the userform and reopen it, it will begin working fine. I have no code that would change the tabkeybehavior, so I'm not sure what would be causing the malfunction. Any ideas on what could be causing this behavior?