CommandButton is used to run or execute a macro or procedure. It performs a task or an action when a user clicks on a command button. Command Button can be used on the WorkSheet. Please find more details about ActiveX CommandButton Control in the following chapter. You can see how we are adding or deleting command button on the Worksheet.



50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates

VBA ActiveX CommandButton Control on the Worksheet

Please find more details about VBA ActiveX Command Button Control on the Worksheet.

  1. Go To Developer Tab and then click Insert from the Controls group.
  2. Click on the Command Button from the ActiveX Controls group.
  3. Drag a Command Button on the Worksheet.
  4. Right click on the Command Button, before that Design Mode should be turned ON.
  5. Click on properties from the available list.
  6. On the left side find ‘Caption’ from the available properties of a Command Button .
  7. On the right side mention as ‘Click’. Please find the below screen shot for the same.
  8. Now, Double click on the Command Button (Click). Or right click on command button and click view code.
  9. Now you can see the following code in the VBA Editor window.
  10. Private Sub CommandButton21_Click()
    End Sub
  11. Now add the following code in between above procedure.
  12. Code:

    Private Sub CommandButton21_Click()
    MsgBox "Hi, Welcome to"
    End Sub
  13. Now, Press ‘F5’ to run the code. You can see the following Output. It is shown in the following Screen Shot.
  14. output:

Delete CommandButton Control on the Worksheet using VBA

Please find the below code, it will show you how to delete or remove a command button on the worksheet. In the below example, its deleting the command button named ‘CommandButton1’ which is on the worksheet named ‘Sheet11’. Here Delete is the property of Shape object.

Sub Delete_CommandButton()
End Sub


  1. rimmy September 4, 2015 at 3:15 AM - Reply

    i want to copy file1 into sheet1 of the master file and file2 into sheet2 of the master file using command button macro
    vba code. please how to write the code for that.

    Thank you.

  2. Kalidass.s January 28, 2016 at 6:22 PM - Reply

    how to control a comment button with another one command button.

    there is two command button in a sheet called
    command button-1 and command button-2

    command button-1 contains the following macro

    so I want to activate the command button-1 by pressing the command button-2

    please give me a solution

    • PNRao January 30, 2016 at 10:57 PM - Reply

      Hi Kalidas,

      Command button is having two properties to handle your requirement.

      Method 1. Enabled property of Command button

      Commandbutton1.Enabled=True ‘This will allow user to click on the button to execute the code inside the command button event.
      Commandbutton1.Enabled=False ‘It will not execute the code even after clicking on it.

      Method 2: Visible Property of the Command button
      Commandbutton1.Visible=True ‘it will display the commandbutton
      Commandbutton1.Visible=False’it will hide the commandbutton

      Hope this helps!

  3. Prince Toms June 21, 2016 at 3:33 PM - Reply

    How can i use toggle button to delete rows and columns ?

Leave A Comment

Related pages

excel vba screenupdatingremove hyperlinks excel 2007microsoft excel unprotect sheetexecutive dashboard templatessas language basicsunhide column in excelexcel concatenatedelete sheet rowsadding macro to excelexcel macro pastehow to protect excel sheet 2007 with passwordexcel hlookupexcel project management templatesif statements vbasort selected cells by last name in ascending orderrows select vbaexcel delete extra rowsexcel delete cellunhiding columns in excelmacro vbaembedded chart in excelhow to use if formula in excel 2007minimise shortcut keyhow to sort from highest to lowest in excelunprotect vbams excel test questions and answerspv table excelexcel cell vbaexcel mysql odbcapplication.wait excel vbavba code for excelhow do i create a pivot table in excel 2007excel macro to copy and pasteunprotect excel file 2010match function vbaword vba saveashow to use sumif function in excel 2010row height exceltechnical interview questions and answers for freshers pdfhow to merge cell in excel 2010excel unlock password protected fileshow developer tab excel 2007vba and macroshow to shade cells in excelexcel delete row vbamessage box vbscell color function exceldatediff vbaword 2013 developer tabpivot table vbadml ddl dcl and tcl in sqladodb connection stringremove blank excel rowshow to copy cells in excelexcel command to insert rowconcatenate excel examplemacros basicsproject mobilization plan samplehow to fix a column in excelexcel find last cellexcel formula isnasubroutine vbahow to use a pivot table in excel 2010vba trim spaceswhat does vba stand forproject reporting template excelexcel vba msgbox inputvisual basic tutorial torrenttrim in excel 2007excel find duplicates in columnsort sql statementpassword protect cells in excelexcel macro queryexcel vba password recovery code