Tab order with check boxes
Hi
How do I incorporate check boxes into my tab order? I'm creating an
excel client form where someone must fill in data in either text, check
boxes and/or drop down lists. I've used the following to set the tab
order
Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
Case "$B$4"
Range("G4").Select
Case "$G$4"
Range("J4").Select
Case "$J$4"
Range("B5").Select
End Select
End Sub
which works for text boxes and drop down lists, but not check boxes.
Any ideas?
Thanks,
Dre
|