Check out this other Excel macros how-to, where there’s a section with detailed instructions on how to create, name, and use macros. Macro2: Organize and sort data ...

However, creating pivot tables manually is a tedious and time-consuming task. This is where VBA (Visual Basic for Applications) comes into play. In this article, we will learn how to create pivot ...

How to Create a Check Box in Excel 2007. Using Excel to create business forms means including elements available on your Web-based and paper forms, including check boxes.

Excel allows you quite a lot of freedom to customize your user experience via the use of macros. This tutorial will show you how to create and name worksheets using an existing list via a macro. You ...

An Excel macro is a sequence of commands (or directives) that you record to perform a series of tasks. We'll show you how to create custom macros for your spreadsheet.

In Excel 2016, Power Query is no longer an Excel add-in but a native feature of Excel, and what’s more, you can now use VBA to create and manage Power Query queries. I’ve found two sources of ...

Just as you can add ActiveX controls to [custom dialog boxes](create-a-custom-dialog-box.md), you can add controls directly to a document when you want to provide a sophisticated way for the user to ...

This topic covers specific information about using ActiveX controls on worksheets and chart sheets. For general information on adding and working with controls, see Using ActiveX Controls on a ...