View original (French)

Change the macro button name

Solved
nonossov Posted messages 638 Status Membre -  
nonossov Posted messages 638 Status Membre -
Hello,
Thank you for helping me with this macro; I want to change the name of the macro button: from CommandButton1_Click to Search.
Note: If no one knows how, we can copy this macro to other macro files without any problem; please help me with this topic, thank you
Thank you so much
https://www.cjoint.com/c/EDotMGVNYzr

Configuration: Windows XP / Chrome 40.0.2214.115

2 réponses

Réponse 1 / 2
PlacageGranby Posted messages 402 Status Membre 26
 
Hello,

To modify the button, you need to be in "Design" mode.
Depending on your version of Excel.
In 2010, I have the Design Mode button in the Developer tab.
In 1997, go to View, enable the Visual Basic toolbar, and you will find the option to switch to "Design" mode.
1
nonossov Posted messages 638 Status Membre
 
I already switched to creation mode and I tried but I succeeded, can you help me??
0
PlacageGranby Posted messages 402 Status Membre 26
 
Small clarification on the manipulation proposed by Ozone_

The NAME property changes the reference name of the button.
The CAPTION property changes what is written on the button.

Follow Ozone_'s approach but write Search in the caption and it should work.
0
ozone_ Posted messages 1823 Status Membre 511 > PlacageGranby Posted messages 402 Status Membre
 
Exactly!
0
nonossov Posted messages 638 Status Membre
 
Thank you Mr. PlacageGranby for the explanation, I managed to change the button name,
what remains is how I export this macro to other Excel files, knowing that I exported the userforms but the button does not appear on the sheet,
what should I do Mr.?
0
Réponse 2 / 2
ozone_ Posted messages 1823 Status Membre 511
 
Hello,

Right-click on the button > Properties >
In (Caption), put whatever you want!

If you can read this you really need to get laid!
0
nonossov Posted messages 638 Status Membre
 
Hello, it's not working, please attach the file.
0
nonossov Posted messages 638 Status Membre
 
I haven't solved my problem yet, please help me.
0