vba to change name of multiple UserForm CommandButtons

[novabond]

hello.
(i dont write code but, can tweak obvious referencies within code.....)
I have been looking online most of today but, I cant find existing code, which i can modify to do something like this:

1)
let say the set up is:
in worksheet "CommandButton Names"
i have a list A1:D20 containing info to change CoomandButton (Name) -
A1:A20 = within Userform (Name)
B1:B20 = from current CommandButton (Name)
C1:C20 = to new CommandButton (Name)
D1:D20 = and new CommandButton Caption (caption change is a bonus, it isnt crucial if complicates things)

e.g.

	A	B	C	D
1	within Userform (Name)	current CommandButton (Name)	new CommandButton (Name)	new CommandButton Caption
2	UserForm_B	CommandButton_A_1	CommandButton_B_1	Caption_B_1
3	UserForm_B	CommandButton_A_2	CommandButton_B_2
4	UserForm_C	CommandButton_A_1	CommandButton_C_1	Caption_C_1​

iit would be ok to do one new userform at a time too, if that makes sense... or any other way you know that will achieve the outcome I want of auto renaming UserForm CommandButtons...

2)
It would also be great, if there was a macro that could export the details of the UserForm CommandButtons too, that would be really useful but, not important...

TIA!....

 

[Bosquedeguate]

Here is an example of a simple for and code that changes captions when the UserForm initializes

Book1
	A	B	C	D	E
1	Form	Control	Caption
2	UserForm1	CommandButton1	Button 1
3	UserForm1		Admin
4
Sheet1

Private Sub UserForm_Initialize()
   Me.Caption = Range("C3")
  CommandButton1.Caption = Range("C2")
End Sub

I added a button on the worksheet to show the form (which runs the UserForm1_Initialize Sub).

You really do not and cannot change your control names dynamically. You event handlers (like the Click) event for your controls are named from the Name of each control.
I you change the control names dyamically (I do not think you can do this at run time), it would render your event handler code useless.

So, you can change Captions, but you cannot change Names.

Dynamically changing captions would be very useful in a multilingual environment.

Labels, Buttons, Forms, OptionButtons, CheckBoxes, ... have Captions that could be changed this way.
Also, messages in MsgBoxes.

I hope this helps.