So i made a userform and the first textbox has a character limit of 4 (for military time input), after the 4 characters it should autotab to the next box. the issue im having is that whenever i open the micro-enabled template, and click on the button to launch the userform, the textbox does not autotab me to the next box. I try pressing enter and nothing, i try using the tab keystroke and also nothing happens. but, if i type something, then erase it and close the userform. the autotab works when the userform is opened again.

anyone got any idea why this happens or how i can fix it?