Hello,

I have a series of three list boxes, two of which only become active if "yes" is selected. I am trying to find code that would either tab into the next list box if yes, or tab into a different list box if "no".

Here is the code I am using to activate the other two list boxes if "yes" is selected:

Private Sub ListBox5_Click()
Dim IsYes As Boolean
IsYes = Me.ListBox5.Value = "Yes"
Me.ListBox6.Enabled = IsYes
Me.ListBox7.Enabled = IsYes
End Sub


And here is the code a I am using to tab from list box to list box:

Private Sub ListBox3_KeyUp(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
If KeyCode = vbKeyTab Then
Me.ListBox4.Activate
End If
End Sub

I am using Excel 07/XP. Thanks for reading, and I greatly appreciate any help!