How to return back to textbox after

Hello,

I have quite some text-boxes for entering data. For user to be efficient i created _Exit event with setting focus on next textbox.
So user can just move to next textbox only with return key, no need to use mouse.
Now comes the problem. If user makes mistake and wants to correct value in previous textbox, textbox cannot be selected because there is _Exit event on next text box which moves focus to next textbox so long that it comes to commandbutton, where it clears all textboxes and set focus on first textbox for new entries.

In the userform there is also listview to immediately reflect entered values.
Does anyone have an idea how to make possibility to be able to correct values in previous textboxes, before coming to commandbutton.

Please Login or Register  to view this content.

Thanks for any suggestion

I attached the workbook.

Thanks buran, it helped