Home > Excel Topics > Macros VBA 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.

Excel Macros These tutorials show how to automate routine tasks, so you can save time while you work.. Copy Code -- 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. Details on the How to Add Macro Code to Excel Workbook page.

	PowerPoint -- Macro quickly creates PowerPoint slides from Excel list. Fill 1 or 2 text boxes in each slide. Use all list items or specific items, based on criteria. Details on the Create PowerPoint Slides From Excel List with Free page.
	Active Cell -- Make it easy to find the active cell on Excel worksheet. Use this macro to highlight active cell with colored lines. Does not affect cell formatting. Details on the Highlight Active Cell on Excel Worksheet page.
	Add-ins -- Install and use Excel Add-ins for extra functionality. Recommended add-ins and installation instructions.. Details on the How to Install and Use Excel Add-ins page.

Buttons -- How to add macro buttons on each worksheet in Excel file, to go to previous or next sheet. Details on the How to Add Worksheet Macro Buttons in Excel page.

Check Box -- How to add check boxes in an Excel worksheet To Do list, and link to worksheet cells, to mark items as completed. Details on the Excel Worksheet Check Box For To Do List Example page.

Check Boxes -- Use Excel macros to add check boxes to worksheet, link to cells, delete check boxes, check all boxes, clear all boxes, run macro when check box is clicked. Details on the Use Macros with Excel Worksheet Check Boxes ✅ Samp page.

Combo Boxes -- Excel macros for worksheet combo buttons. Click button to quickly sroll through combo items. Create list of all combo buttons with details. Sample Excel files.. Details on the Excel Worksheet Combo Box Macros-ActiveX-Form Cont page.

Comment Macros -- Add, format, copy, move or resize comments. Change commenter name. Number comment cells, print numbered list. Add pictures in comments. Details on the Comment Macros Examples Resize Print Move page.

Comments -- Comment macros to remove author name, change font or font size, move or resize comments, or add/remove comment shadows. Details on the Excel Comment Macros page.

Date Picker -- Use this Excel Date Picker to select dates for a worksheet cell, or create a quick month or year calendar to sheet. Code is unlocked, to see how it works.. Details on the Use This Free Excel Date Picker to Enter Dates on page.

Email -- Simple steps to send emails from Excel with PDF attachment. Put email addresses in list, choose folder, click macro button for test email, then send to list. Details on the Send Email from Excel with PDF Attachment page.

Excel Settings -- How to change Excel calculation options with command buttons or macros. Tricks to see which calculation mode is active, and prevent calculation problems. Details on the Excel Calculation Options and Setting Macros page.

Excel Tables -- Use these macros to copy selected items in an Excel table, and paste at the end, or below the last selected item. Get the free workbook to test the code.. Details on the Macro to Copy Selected Items in Excel Table page.

FAQs -- Frequently asked questions (FAQ) about Excel macros, Excel VBA and User Defined Functions (UDF). Details on the FAQs for Excel Macros Excel Programming Excel VBA page.

Files -- Use these macros to list all the files in a specific folder, with file properties, such as name, size, date.. Details on the Excel Folder File Macros page.

Form Controls -- Instructions and sample macros to work with the form control buttons on a worksheet. Details on the Macros for Excel Form Control Buttons page.

Formula Audit -- Audit Excel Formulas- On copy of active sheet, macro colour codes formula cells that have been copied across, down, or both. Spot problems and fix them. Details on the Excel Formula Cell Colour Code Macro page.

Freeze and Zoom -- Sample Excel macros to freeze and zoom worksheets with VBA. Change settings on all sheets in workbook, set sheet zoom level, freeze or unfreeze. Details on the Excel Worksheet Freeze and Zoom Macros All Sheets page.

Golf Tee Off -- Use this Excel golf tee off times template to set player tee off times for golf tournaments, or for golf course daily bookings. Video, Excel file. Details on the Organize Golf Tee Off Times Excel Workbook page.

List Box -- How to create an Excel VBA List Box that shows a list of items users can select. Then, send selected items to worksheet. Video and written instructions.. Details on the How to Show a List Box in Excel page.

List Files -- At end of work day, use this macro to list and close all open Excel files. Next day, click button to open those files again. Like Excel's old Workspace feature. Details on the List and Close All Excel Files page.

ListBox -- How to move Excel ListBox items. Example code to move all items or selected items. Get the free workbook. Details on the How to Move Excel Worksheet ListBox Items to Other page.

Messages -- Show warning messages in Excel workbook. Give automatic alerts, data entry tips. See steps in short videos, written steps. Get sample files with VBA code. Details on the Show Warning Messages in Excel Examples page.

Named Ranges -- Quickly create dynamic named ranges in Excel with a macro. Use those dynamic ranges in formulas and pivot tables.. Details on the How to Create Dynamic Ranges in Excel With Macro page.

Names -- Use macros to work with Excel names. List all names, with details, to see where each range is located. Details on the Excel Names Macros List All Names with Details page.

Navigation -- Excel Navigation toolbar for workbook sheets, creates floating toolbar with list of sheets. Details on the Excel Addin to Navigate Sheets page.

Navigation -- Quickly select a sheet from this popup list that stays open while you work in Excel. Get the free workbook and instructions.. Details on the Free Excel Sheet Lister Add-in page.

PDF -- How to save Excel sheets or workbook to PDF. Step-by-step or use time-saving Excel macro. Fix PDF error. PDF setup tips, video, download Excel file. Details on the Save Excel to PDF-VBA Macro Step-by-Step Tips Vide page.

Printing -- Use this sample Excel macro to print the marked items in an Excel order form. Details on the Print Selected Items in Excel Order Form With This page.

Protection -- Quickly protect or unprotect all worksheets. Just choose TRUE or FALSE from drop down list, to run macro. Save time when updating files. Free download. Details on the Excel Protect Unprotect All Sheets Using Drop Down page.

Record -- How to record and run an Excel macro, for absolute beginners. Video and written step-by-step instructions. Get started with Excel programming.. Details on the How to Record and Test Excel Macro page.

Ribbon -- How to add a custom tab to the Excel Ribbon. Custom tab appears when specific workbook is opened, hidden for other workbooks. Get the free Excel file. Details on the How to Add Custom Tab for Specific Workbook on Exc page.

Ribbon -- Quickly add your Excel macros to buttons and drop down lists on Excel Ribbon macros tab. Get free workbook, make easy changes, so tab shows for all files. Details on the How to Add Your Excel Macros to Custom Ribbon Tab page.

Ribbon -- See how a custom tab is added to the Excel Ribbon, and set up macros to run when a Ribbon button is clicked. Details on the Excel Ribbon Custom Tab How to Get Started page.

-- Use this free Excel add-in to show Filter commands at the top of the right-click menu. Makes it quick and easy to apply or clear filters. Contributed by AlexJ. Details on the Excel Filter Right-Click Macros page.

Scenarios -- Use these macros to create a list all the scenarios, or create new scenarios, or update the values for existing scenarios, from a list on the worksheet. Details on the Macros for Excel Scenarios page.

Scenarios -- For Excel Scenarios, use a macro to automatically show selected scenario. Step by step instructions and free workbook. Details on the Use This Macro to Automatically Show Excel Scenari page.

SendKeys -- How to use SendKeys method in Excel macros to replace manual keystrokes. Get the free workbook with example and list of keys and key combinations. Details on the How to Use Excel SendKeys Method in Macros page.

Slicers -- Use Excel VBA programming to change one slicer when another is changed.. Details on the Update Excel Slicers with Macro page.

Slicers -- Save worksheet space with this Excel pop up Slicer selector. Click button to show Slicer only when needed. Details on the How to Make Space Saving Excel Pop Up Selector Wit page.

Sorting -- Quickly sort Excel data with macros. Click hidden shape at top of column, to sort by that column. Click again to sort reverse order. Details on the Excel Sort Data With Macros page.

Table Name -- Get Excel Table name or Pivot Table name on worksheet, using User Defined Function in VBA.. Details on the Get Excel Table Name or Pivot Name Formula or UDF page.

Tables -- Use these macros to list all the Excel tables in a workbook, get sheet names where tables are stored, fix problem - table does not expand automatically. Details on the Excel Table Macros page.

Text -- Use these Excel macros to work with text. Combine text from 2 or more cells, delete rows if specific words are found or not found. Videos, free workbook. Details on the Use These Excel Macros to Work With Text Combine o page.

Text Box -- How to add an ActiveX Text Box to an Excel worksheet, for data entry. Details on the How to Create Excel Worksheet VBA Text Box ActiveX page.

Threaded Comments -- Use these Excel threaded comment macros to list all threaded comments, list all comments and replies, and show or hide all threaded comments. Free Excel file. Details on the How to Automate Excel Threaded Comment Macro Examp page.

Troubleshoot -- Troubleshoot Excel macro error message. Debug to fix simple problem. Fix error Invalid forward reference. Fix F8 key stops working. Show Project Explorer. Details on the Excel Macro Troubleshooting Tips Debug and F8 Key page.

Worksheet -- Excel macros for worksheet tasks - clear hyperlinks, find filled cells, fix numbers with trailing minus signs. From from Rick Rothstein. Details on the Excel Macros for Worksheet Text Number Tasks Rick page.

Worksheets -- Save time with these Excel macros - add sheets, fix gridlines, hide and protect, list all sheets, format footers + more. Videos, Excel files, written steps. Details on the Excel Worksheet Macros to Create Edit Hide Protect page.

Worksheets -- Select Excel sheet type from drop down list to see only those sheets, all others hidden. Details on the Show Excel Sheets by Tab Color - Macro Example Wit page.

Worksheets -- Organize Excel sheets by tab color, run macro to show only sheets with specific color. Details on the Show Excel Sheets by Tab Color page.

Zip Files -- Excel macro updates sheet in all workbooks in specific folder. Optional zip each file after update. Details on the Use This Macro to Update and Zip All Folder Excel page.

Excel UserForms These tutorials show how to automate routine tasks, so you can save time while you work.. Create -- Build an Excel UserForm for data entry, with text boxes and buttons. Step-by-step videos, detailed notes with screen shots, free Excel workbook. Details on the Build an Excel UserForm for Data Entry Step by Ste page.

Combo Box -- How to use an Excel ComboBox with a drop down list to make data entry easy in an Excel UserForm. Details on the Excel ComboBox Lists for Easy Data Entry page.

Combo Box -- Excel VBA example shows how to restrict a combo box in a UserForm, so only items that match a list can be entered. Details on the Excel ComboBox Match Required VBA page.

Combo Box -- In Excel UserForm, make it easy to enter data. Add dependent combo boxes - list in one combo box depends on selection in another combo box. Details on the How to Build Excel UserForm With Dependent ComboBo page.

Combo Boxes -- Tips for using Excel UserForm combo boxes - show column heads, set widths, and more. Get the free workbooks with examples. Details on the Excel UserForm Combo Boxes page.

Comboboxes -- Excel UserForm tutorial: make it easy for users to enter data; include combo boxes with drop down lists; tutorial with step by step instructions. Details on the How to Make an Excel UserForm with Combo Box for D page.

Listbox -- How to move ListBox items on an Excel UserForm. Click button to move all items or selected items. Get free workbook.. Details on the Move Listbox Items in Excel UserForm With Button C page.

MultiPage -- How to make an Excel UserForm with MultiPage Help tabs that show worksheet instructions. Help buttons on worksheets open form at related page tab. Details on the Excel UserForm MultiPage Help Tab Buttons page.

Open -- See 4 ways to open Excel UserForm- in VBE, worksheet button, keyboard shortcut, automatically when file opens. Step-by-step instructions, Excel file. Details on the Open Excel UserForm Automatically or Button page.

Search Box -- Excel UserForm for transaction record data entry. Add new records, or use Search criteria to find existing records, and view, edit or delete them.. Details on the Excel UserForm Search Add Edit page.

Text Boxes -- Sample code to use with Excel Userform TextBox. Check for specific character, check number of characters. Details on the How to Create Excel UserForm TextBox Code Example page.

Get Monthly Excel Tips! Don't miss my monthly Excel newsletter! You'll get quick tips, article links, and a bit of fun. Add your email, and click Sign Up. Next, when you get my reply, please click the Confirm button. I add this step to protect you from spam!

Excel Topics Data Validation | Pivot Tables | Formulas | Data | Macros | Format | Charts | Filters | Structure