Yeah, getting User Work-Flow to work using only TabIndex can be hard, you can skip around with 
Private Sub SomeControl_Exit(ByVal Cancel As MSForms.ReturnBoolean)
   Cancel = True
   OtherControl.SetFocus
End Sub
Think of it as GoTo for TabIndex, so use it sparingly.