Prevent "Backwards" Tab in Userform

[Garrek]

I have a userform with a bunch of text boxes, and on the bottom a Submit and Cancel Button. I want to be able to tab through these, but because the Cancel button is the last in the TabIndex, if a user is holding Shift and presses tab, it will go "backwards" to select the cancel button. Is there any way to prevent this? I don't want to allow this backwards tabbing from the first text box

 

[mikerickson]

You could try adding this code

Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
    If Shift And KeyCode = vbKeyTab Then
        KeyCode = 0
        Beep
    End If
End Sub