A convenient way to batch rename ( not caption ) multiple command buttons on Userform ?

[smallxyz]

Hi,
I am creating an Userform with several command buttons on it.


Is there a way to batch rename them as :
cbButton1
cbButton2
cbButton3
cbButton4
cbButton5
… ?


Note: I hope to give new names to them. not to change their captions.
The way I am using now, is simply click on them 1-by-1, and the adjust the "name" field, which is not very efficient for a large size of command buttons.





Thanks a lot!

 

[Kyle123]

This sounds a little bit odd if you don't mind me saying. Why do you need to change their names?

 

[smallxyz]

This sounds a little bit odd if you don't mind me saying. Why do you need to change their names?

for the sake of code readability.

 

[John_w]

See https://www.tek-tips.com/viewthread.cfm?qid=1286170

The code might need tweaking for more recent Excel versions and the particular way you want to rename the buttons. Note that it also renames them in the userform's code module.

You will need to add the reference to MS VBA Extensibility, and Trust access to the VBA project via Macro Security in the Developer tab on the main Excel ribbon.

 

[smallxyz]

Thanks John_w.
I will take a look on it.