With the VBA, buttons can invoke the macros, display the messages and perform other functions. Use VBA in order to add more functionality to Excel worksheets without possessing knowledge of technical ...

Exit Sub Err_Command13_Click: MsgBox Err.Description Resume Exit_Command13_Click Press [Alt]Q. When you press the command button, the Hours Worked table will receive the data in the Excel file.

Right-click the new command button and highlight the default "Button 1" text. Change the button label text to "Quick Print" or another descriptive name. Click the new command button.

In the drop-down box, click and select the "Button" control in the Form Controls section. Click the cell in the Excel spreadsheet where you want the command button control to appear.

Once the command moves to the right column, click OK to save changes. The Repeat command will be added to the toolbar. It will get activated when you perform an action in Excel.

Now that I have shown you how to create a button within an Excel spreadsheet, I want to move forward with using that button to launch a PowerShell script. I will show you how in Part 2.