HDTutorial
EN
How to Create Macro Buttons in Excel Worksheets

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Create Macro Buttons in Excel Worksheets

830,765 views October 26, 2019 8:29

Watch on YouTube
ChannelExcel Campus - Jon

Chapters

Description from the creator

Sign up for our Excel webinar, times added weekly: excelcampus.com/blueprint-registration/

In this video I explain the 3 ways to create macro buttons in Excel worksheets. These are buttons that run macros when the button is pressed. Download the Excel file:

There are 3 ways to add macro buttons to a worksheet in Excel:
1. Shapes
2. Form Control buttons
3. ActiveX buttons

In the video I explain my favorite method, and the pros & cons of each.

I also explain how to prevent the buttons from moving and resizing when changes are made to the sheet. This can happen when you add/remove rows & columns, or adjust row height or column width.

Adding macro buttons to your spreadsheets can make it much easier for other users that are not familiar with Excel. Instead of having them complete a bunch of steps in a complex process, they can just click a button to run a macro. The macro runs your VBA code that automates the task(s).

Additional Resources:

How to Enable the Developer Tab in Excel: youtu.be/JLQ8OuW0FlY

How to Add Macro Buttons to the Ribbon (Toolbar) in Excel: youtu.be/dmdolFcS-fI

How to Add a Yes/No Pop-up Message Box Before a Macro Runs: youtu.be/rCh7ki9yVsM

Create Macro Buttons for Filters in Excel: youtu.be/a8r20T1c_JU

Create Macro Buttons for Pivot Tables: youtu.be/vLISpSGKhlQ
00:00 Introduction
00:24 VBA Edito
00:58 Insert Tab
01:35 Assigning a Macro
04:07 Moedifying the Shape
05:42 Form Controls

About this tutorial

Excel Campus - Jon published this 8:29 video tutorial on October 26, 2019. It has been watched 830,765 times on YouTube.

Category
Education
Duration
8:29
Published
October 26, 2019
Views
830,765
Likes
4,934

Tags

Share

Further reading

  • How to Add a VBA Button in Excel? - Overview, Types corporatefinanceinstitute.com

    Adding buttons to the worksheet will help expose other users to the custom functionality of your workbook. When a VBA button is clicked, it automatically activates a macro, and it eliminates the need to use the Develope…

  • Excel Personal Macro Workbook: how to create, use and share ablebits.com

    So, before we get started, please make sure the Developer tab is activated in your Excel. To create the Excel Personal Macro Workbook, carry out these steps: In any workbook, go to the Developer tab > Code group, and cl…

  • How to Create Macro Buttons in Excel Worksheets excelcampus.com

    In my opinion, the best way to create macro buttons is to use shapes. Shapes give us the most styling/formatting options, and we can make them look like buttons you click every day on modern web pages. Below, we will cr…

This tutorial in other languages