Is there a reason why you don't want to use the 'TabIndex' property of the
objects on the form?
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Dre" wrote:

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