Do userform controls have an index number

Hello jerseyguy1996,

Each control is part of the UserForm's Control collection. Each object in a collection can be referenced either by it key value, a string that holds the objects name, or an index value that points to position within the collection.

If you loop through the collection by index value, you will still need to check the control's name against a list. The easiest way to do this is with a Select Case statement that contains the names of the controls you don't want to delete. Add the names to the macro you want to keep.

Please Login or Register  to view this content.

Originally Posted by Leith Ross

Hello jerseyguy1996,

Each control is part of the UserForm's Control collection. Each object in a collection can be referenced either by it key value, a string that holds the objects name, or an index value that points to position within the collection.

If you loop through the collection by index value, you will still need to check the control's name against a list. The easiest way to do this is with a Select Case statement that contains the names of the controls you don't want to delete. Add the names to the macro you want to keep.

That's perfect. I actually got away with a slight variation of that. I know that the controls that I want to keep are indexed 0 - 8 so my code is:

Please Login or Register  to view this content.

Its kind of interesting to me that the index number goes after "Remove" rather than after "Controls". Why is this? It seems that with all of the other collections that I have worked with, the index number goes after the collection name as in:

Please Login or Register  to view this content.

rather than

Please Login or Register  to view this content.

Hello jerseyguy1996,

I have often wondered the same thing.