Thanks All

I opted to deleted and re-create each of the checkboxes on
the form. I did this mostly because the rest of the code
was already written and was contingent upon a certain
naming convention for the chckboxes.

I completed the re-creation and tested it and it worked
fine. It would seem that Microsoft would use the TabIndex
Property rather than the Control Index Number to allow for
control by the developer.

Allan
-----Original Message-----
I think that as you are accessing each member of the
control collection
you are doing this in the same order as the control index
number.
This is set at the time that the controls are added to
the form,
starting at one, and incrementing for each new control.

I think it is possible to construct code to reorder the
controls within
the collection, however it probably will require you to
delete and
recreate the controls. That sounds like a lot of work.

It may be easier to test the value of each control in
your desired
sequence than to reorder.


---
Message posted from http://www.ExcelForum.com/

.