Macros & Excel VBA

How to Make a Recalculate Button in Excel (5 Easy Steps)

The Recalculate button allows you to update formulas in your dataset. If you’re using volatile functions that change over time, you’ll need to ...

How to Create Toggle Button on Excel VBA UserForm

  Step 1 - Launch the Excel Developer Tab If you have the Developer tab on your ribbon, you can skip this step. Right-click on the ribbon ...

How to Open an Existing PowerPoint File using Excel VBA – 5 Steps

You have a blank PPT file saved in Drive (D:). Step 1 - Launch the Developer Tab Right-click the ribbon. Select Customize the ...

How to Count Colored Cells in Excel with VBA (4 Methods)

The sample dataset contains students' marks in two subjects. We will fill with green or yellow to highlight marks greater than 80 or less than 50 ...

How to Import Data from Google Sheets to Excel Using VBA – 3 Steps

The name of the sheet is Importing Data to Excel. The dataset includes Sales Rep, Product Name, Unit, and Sales. Step  1 - Change the Privacy of ...

Creating a Barcode Scanner Macro in Excel: 5 Methods

Method 1 - Compiling the Barcode into Excel Worksheet Compile the scanned barcode numbers into a worksheet, as depicted in the image below. You have ...

How to Create and Apply an Option Button Click Event in Excel VBA -2 Steps

Introduction to the Excel VBA Option Button The option button refers to a type of icon that allows the user to choose just one option. You can add ...

How to Change the Color of the Toggle Button When Pressed in Excel – Examples

Example 1 - Changing the Toggle Button Color When Pressed Steps Go to the Developer tab and click Insert. (Click the link to enable the ...

How to Create Button to Link to Another Sheet in Excel (3 Ways)

We will show you how to create a button to link to another sheet by inserting Shapes, using the Button from Form Controls, and the Command Button ...

How to Add Option Button in Excel (With Easy Steps)

Consider the following dataset of fruit items and two stores. We'll insert option buttons so we can use this dataset to input data in other sheets. ...

How to Spell Out Number Without Currency in Excel (2 Methods)

Dataset Overview Let’s say, we have a dataset with some Numbers with 2 decimal points. Our goal is to spell these numbers in words without ...

How to Group Radio Buttons in Excel (2 Simple Methods)

In this article, we will cover 2 simple methods to group radio buttons in Excel. Suppose we have the following dataset of a Company’s monthly ...

Change Cell Value Using Toggle Button in Excel: 6 Suitable Examples

Method 1 - Increase Cell Value by Toggle Button Steps: Insert a toggle button from the drop-down arrow of the Insert option of the Controls ...

How to Add Up and Down Buttons in Excel (With Easy Steps)

This article will demonstrate how to add up and down buttons to increase and decrease cell value in Excel. How to Add Up and Down Buttons in ...

How to Remove a Form Control in Excel (3 Ways)

The List of Employee Names dataset displays the ID and Employee Names. We can use the Scroll Bar to move across the list of employees. You can remove ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo