Key Skills > Macros

Excel Macro Topics on Contextures

Use Excel macros to automate routine tasks, so you can save time while you work. Record and edit your own macros, or use code that you find here on my Contextures site.

Author: Debra Dalgleish

Excel Macro Tutorials

These tutorials show how to automate routine tasks, so you can save time while you work.

1 -- How to Add Macro Code to Excel Workbook -- How to copy Excel macro VBA code to your workbook, from website or sample file. Different types of code, where to paste it. Step-by-step videos, written steps

2 -- Excel Macro to Save Sheets As PDF -- Excel macro saves active sheet or sheets in PDF format, prompts for file name and folder. See macro code, get sample workbook with macro.

3 -- How to Create Excel UserForm for Data Entry -- See how to create an Excel UserForm for data entry, with text boxes and buttons. Follow step-by-step videos, detailed notes with screen shots, free Excel workbook

4 -- Excel ComboBox Lists for Easy Data Entry -- How to use an Excel ComboBox with a drop down list to make data entry easy in an Excel UserForm

Excel Macro Videos

Here's one of my latest Excel macro videos, and almost all of my Excel macro tutorial pages include a video too.

This short video shows how a completed UserForm works, so you can see the end result, before you start to build your own UserForm. There are written steps, more videos, and sample file on the Make an Excel UserForm for Data Entry page.

Excel Macros - Sample Files

Here are the download links for a couple of my latest Excel macros sample workbooks, and most of the tutorial pages include a sample file too.

More Workbooks: For even more macro sample files, go to the Excel Sample Files page, and scroll down to the UserForms, VBA, Add-Ins section.

Macro Lists All Sheets With Info -- Create a list of sheets in the active workbook, with details on cells used, and sheet contents.
Excel File: List All Sheets With Info (has macros)