Changing Form Control Names in a loop

[dougman824]

Hello,

I currently have what will amount to be 300 controls that need new names and in some case captions. They follow an easy to loop through naming convention so I am trying to write a simple macro to save me a few hours worth of clicking and typing. I am getting an error of can not set the name property. Can not set property at runtime. I am wondering if this means I am out of luck and get to spend the rest of the day clicking around or if my code below just has errors.

Please Login or Register  to view this content.

Thanks

[sintek]

Upload a sample file we can make use of please...

[dougman824]

It is a massive form so I did not take the time to clear everything out but I want to update the Paper Machine Page which is on the Systems Page. I am adding 20 more lines to the frame there and I need them to follow the same naming convention for looping purposes in the rest of the code I have. I will end up needing to do this in a few other places as well as add a few new columns to the frame but if I can get the 20 new to work I can adjust for the rest.

Form is FSRForm

Code in Module 1

[sintek]

Firstly, it is not possible to change the controls name while code is running...Can set it via Property...
Caption change is as per your code...Put your code in a command Button on userForm.

Please Login or Register  to view this content.

[dougman824]

That's unfortunate thanks