Do userform controls have an index number

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.

??

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

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.

Hello jerseyguy1996,

I have often wondered the same thing.