I understand that you are trying to emulate the UserForm's Tab action on a Worksheet.

Why doesn't Setting the Sheet's ActiveX controls' TabKeyBehavior Properties to True work for you?