How to Insert a Combo Box in Excel

How to Insert a Combo Box in Excel

A combo box - also known as a dropdown control - allows selecting an input from a list of options. In this guide, we’re going to show you how to insert a combo box in Excel. Download Workbook Please note that this is a guide to insert a form control combo box which is...
How to insert a spin button in Excel

How to insert a spin button in Excel

A spin button is a control that allows users to select a numeric value from a specific range. These buttons consists of two arrow and look like scroll bars without the scroll. In this guide, we’re going to show you how to insert a spin button in Excel. Download...
How to show a closing message in Excel

How to show a closing message in Excel

In this guide, we’re going to show you how to show a closing message in Excel by using macros. Download Workbook ThisWorkbook object and Workbook_BeforeClose Event If you want to trigger any action at the before closing of your workbook, you must add your code under...
How to insert a Slider in Excel

How to insert a Slider in Excel

A slider is a control that allows selecting a numeric value from a certain range. In this guide, we’re going to show you how to insert a slider in Excel. Download Workbook Developer Tab and Scroll Bar command The command for adding option buttons can be found under...
How to insert a button in Excel

How to insert a button in Excel

In this guide, we’re going to show you how to insert a button in Excel. Download Workbook Developer Tab and Button command The command for adding option buttons can be found under the Developer tab, which is not active in Excel by default. This tab contains macro...
How to send email in Excel

How to send email in Excel

You can’t send emails directly form Excel, but there are a few ways to trigger the default mail client on your computer. In this guide, we’re going to show you how to send email in Excel. Download Workbook Send email with attachment If you want to send the file...
How to insert a toggle in Excel

How to insert a toggle in Excel

A toggle button allows selecting from two options: They are like on/off switches or Play/Pause buttons. In this guide, we’re going to show you how to insert a toggle in Excel. Download Workbook Excel supports toggle buttons as development tools.You can assign them...
How to automate Goal Seek in Excel

How to automate Goal Seek in Excel

Goal Seek runs calculations repeatedly (iteratively) to find possible outcome values for your inputs. In this guide, we’re going to show you how to automate Goal Seek in Excel. Download Workbook Scenario Let's take a look at a basic example. There are two inputs...
How to AutoFit rows using macros in Excel

How to AutoFit rows using macros in Excel

In this guide, we’re going to show you how to autofit rows using macros in Excel. Download Workbook Autofit Method You can use the AutoFit feature by calling the method with same name: AutoFit. The AutoFit method is defined under Range object which represents a cell,...