View original (French)

Change the macro button name

Solved
nonossov Posted messages 638 Status Member -  
nonossov Posted messages 638 Status Member -
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 answers

  1.
    PlacageGranby Posted messages 402 Status Member 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
    1. nonossov Posted messages 638 Status Member
       
      I already switched to creation mode and I tried but I succeeded, can you help me??
      0
    2. PlacageGranby Posted messages 402 Status Member 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
      1. ozone_ Posted messages 1823 Status Member 511 > PlacageGranby Posted messages 402 Status Member
         
        Exactly!
        0
    3. nonossov Posted messages 638 Status Member
       
      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
  2. ozone_ Posted messages 1823 Status Member 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
    1. nonossov Posted messages 638 Status Member
       
      Hello, it's not working, please attach the file.
      0
    2. nonossov Posted messages 638 Status Member
       
      I haven't solved my problem yet, please help me.
      0