I have a frame containing a dozen or so check boxes.

They've been added at various times and I've probably deleted some and
added others.

In some code I count the number of controls, and in a loop with say
'x' as a loop counter, I test the tag property of the control(x). I've
been having some problem with this and I now realise that what I
believed to be say the 3rd checkbox, ( because I thought it was the
third one I'd added), is actually recognised by VBA as say the 5th
checkbox, (identified by the x counter). i.e. Controls(x)

It seems clear that in all my additions and deletions, the system
number of the control is different to what I think it is.

My question is, is there any way of re-setting the system numbers of
these controls so that they line up with the order in which they
appear in the frame?

An associated question. Is there any way of observing directly what
the control number of a particular control is? I can obviously work it
out indirectly by writing a bit of code which tells me say the Tag or
Caption associated with a particular control, but it's not immediately
apparent if the system number is a property of the control which can
be viewed - and changed (in a similar way to the way in which the Tab
property number can be changed).

Rgds and usual TIA





__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________