UserForm Tab/Enter Keys quit functioning

[Big Lar]

With Excel 2003(SP3)…on occasion, my UserForm’s Tab/Enter functions cease to function.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
After Textbox data entry, Tab keystrokes tab inside the TextBox and Enter keystrokes do nothing. The lock up occurs randomly, on different TextBoxes. And once the lockup occurs, it continues every time the application is started.
<o></o><o></o>
Users can still select Textboxes with mouse clicks and enter data into TextBoxes and all procedures continue to function.<o></o>
<o></o><o></o>
I can resolve the lockup by entering VBA editor, Select All UserForm code, Cut, and Paste the code back into the UserForm module.<o></o>
<o></o>
Any idea why this happens? And, is there a resolution?<o></o>

 

[bertie]

You can set the tab order for controls from within the VBA Editor.

Select View => Tab Order

Use the Move Up/Down buttons to set the tab order for the controls.

 

[RoryA]

It may be that your workbook is becoming corrupt. I'd try running Code Cleaner on it first and see if that helps.

 

[Big Lar]

Thanks Rory...
I'll give Code Cleaner a try.