Renaming Textbox Controls

**BillWilts** · 10-13-2010, 04:52 AM

I am trying to sequentially rename the textboxes on my userform. Whatever I try I end up with errors. (Runtime error 382 'Could not set the name property. Can not set property at run time') I have tried adding the code to Userform_Initialize and everywhere else but with no success. Help would be appreciated. This is my code:

Please Login or Register  to view this content.

**romperstomper** · 10-13-2010, 05:54 AM

The error means exactly what it says - you can't do that (why would you want to?)

Note: when posting code on the forum, you must use code tags, please. I have added them for you here as it's your first post, but please use them in future.

**BillWilts** · 10-14-2010, 04:08 AM

The reason behind the question is that I would like (as phase 2 of my current project) to build a multipage form with textboxes that can be added or deleted dynamically. Renaming the textboxes would allow me to simplify the process of populating the textboxes with data and writing the changes back to the spreadsheet. It's much easier to loop through a contiguous range!

**romperstomper** · 10-14-2010, 04:18 AM

If you add the textboxes dynamically, you can name them as you add them. I still can't see a reason for needing to change the names.

**BillWilts** · 10-14-2010, 07:53 AM

Originally Posted by romperstomper

If you add the textboxes dynamically, you can name them as you add them. I still can't see a reason for needing to change the names.

Thanks for pointing me in the right direction! I now have some code to create the boxes but am having a mental block regarding referencing them. Obviously they don't exist until the form is visible so 'Userform1.TextBox1.Value = ...' does not work. Can you give me some idea as to how they should be referenced?

This is the code to create them.

Please Login or Register  to view this content.

**romperstomper** · 10-14-2010, 07:57 AM

You can use:

Please Login or Register  to view this content.

in a loop. Typically though you would use a class to control the controls you add at runtime, depending on why you added them and what you are doing with them.