Can a String (from concatenate) be converted to variable name?

**SidewinderAM9M** · 07-06-2013, 11:08 PM

Please Login or Register  to view this content.

It would be really nice if I could use some function that would allow the following in place of above.

Please Login or Register  to view this content.

The TableX_Label variables are UserForm Labels. Just wondering if there was a way to accomplish this without a User Defined Collection or looping through UserForm objects. Maybe I'm looking for easier ways to do things when I should just use what I know and maybe I just lack a more in depth understanding of VBA but either way it seems like it would be useful to have some way to do this.

**AlphaFrog** · 07-06-2013, 11:32 PM

Try this...

Please Login or Register  to view this content.

The Controls collection is a collection of all the control objects in the UserForm. You can reference a specific control in the collection by string name or by index number.