Do userform controls have an index number

[jerseyguy1996]

The form that I have created has a number of controls that are created at runtime. If a user triggers the event that originally created the controls, I want to be able to delete all of the controls before recreating them. Is there a loop that can delete all of the newly created controls? I have 9 controls on the form that need to stay put but everything after those 9 controls I want to delete. Is there something like:

Please Login or Register  to view this content.

??

[royUK]

There is no Index number, can you explain more fully what you are doing. A sample workbook might help

[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.

Please Login or Register  to view this content.

[jerseyguy1996]

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.

[jerseyguy1996]

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.

[Leith Ross]

Hello jerseyguy1996,

I have often wondered the same thing.