Macros & Excel VBA

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 ...

Excel VBA: Merge Multiple CSV Files into One Workbook 

It is very common to convert CSV files to Excel files. In this article, you will learn how you can Merge Multiple CSV Files into one Excel Workbook ...

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 Add Command Button Programmatically with Excel VBA

Adding buttons is one of those interesting features you can use in Excel VBA. Along with these buttons, you can also add functionality within the ...

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 Use Option Button in Excel (2 Easy Ways)

In Excel, radio buttons are also referred to as "Option" buttons. They are employed to log user input into Excel. They can be found under the ...

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 ...

How to Add Radio Buttons in Excel (2 Effective Ways)

This article illustrates how to add radio buttons in Excel. The radio buttons, usually known as option buttons, let users choose from different ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo