REAL-TIME

VBA Projects

Full Access with Source Code
  • Designed and Developed by PNRao

  • Full Access with VBA Source Code

  • Well Commented Codes Lines

  • Creative and Professional Design

Effortlessly
Manage Your Projects

120+ Project Management Templates

Seamlessly manage your projects with our powerful & multi-purpose templates for project management.

120+ PM Templates Includes:
  • 50+ Excel Templates

  • 50+ PowerPoint Templates

  • 25+ Word Templates

Share Post

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.

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.

CommandButton Excel VBA ActiveX Control2

    1. Now, Double click on the Command Button (Click). Or right click on command button and click view code.
    2. Now you can see the following code in the VBA Editor window.
Private Sub CommandButton21_Click()

End Sub
    1. Now add the following code in between above procedure.

Code:

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

output:

CommandButton Excel VBA ActiveX Control66

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()
    Sheets("Sheet11").Shapes("CommandButton1").Delete
End Sub
Effortlessly Manage Your Projects and Resources
120+ Professional Project Management Templates!

A Powerful & Multi-purpose Templates for project management. Now seamlessly manage your projects, tasks, meetings, presentations, teams, customers, stakeholders and time. This page describes all the amazing new features and options that come with our premium templates.

Save Up to 85% LIMITED TIME OFFER
Project Management Templates

All-in-One Pack
120+ Project Management Templates

Essential Pack
50+ PM Templates

Excel Pack
50+ Excel PM Templates

PowerPoint Pack
50+ Excel PM Templates

MS Word Pack
25+ Word PM Templates

Ultimate Project
Management Template
Ultimate Resource
Management Template
Project Portfolio
Management Templates
Last Updated: March 2, 2023

4 Comments

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

    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

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

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

    command button-1 contains the following macro
    Range(“A1”).Select

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

    please give me a solution

  3. PNRao January 30, 2016 at 10:57 PM

    Hi Kalidas,

    Command button is having two properties to handle your requirement.

    Method 1. Enabled property of Command button

    Example:
    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!
    Thanks-PNRao!

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

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

Leave A Comment