Tab Order in UserForm of Controls Across Multiple Frames

[poopiebear]

Hello. I have a userform with 3 frames. Each of the frames have controls within them. I want to be able to tab not only within a single frame, but also across different frames. Is this possible.

For example:

Frame1 - ComboBox1, Textbox1, Textbox2, Textbox3, Textbox4
Frame2 - OptionButton1, OptionButton2
Frame3 - Textbox5, Textbox6

Tab Order:

Frame1.ComboBox1 > Frame2.OptionButton1 > Frame2.OptionButton2 > Frame1.TextBox1 > Frame1.TextBox2 > Frame3.Textbox5 > Frame1.TextBox3 > Frame1.TextBox4 > Frame3.Textbox6

Thanks!

 

[poopiebear]

I think I figured it out. First, I set the tab order from the Properties in each Frame. When I reach the control that I want to jump from one frame to another, I use this code:

Private Sub TextBox2_KeyDown(ByVal KeyCode As msforms.ReturnInteger, ByVal Shift As Integer)
If KeyCode = 9 Then
TextBox5.SetFocus
End If
End Sub
 
Private Sub TextBox5_KeyDown(ByVal KeyCode As msforms.ReturnInteger, ByVal Shift As Integer)
If KeyCode = 9 Then
TextBox3.SetFocus
End If
End Sub