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 Excel macros that you find here on my Contextures site.

	Excel Macros
	Set up a momthly template sheet in your workbook, and use this macro to automatically create a copy of that template sheet each month, named for the month and year. Watch the video below, to see the steps, and there are written steps on the Add Sheets Automatically page.

Get Started -- See how to record, edit and run an Excel macro, for absolute beginners. There's a video and written step-by-step instructions on the How to Record and Test Excel Macro page.

	Excel UserForms
	Enter inventory data by opening the UserForm, filling in the boxes. Then, click a button to store the data on a hidden worksheet. In the video below, I show how the UserForm works, and there are written steps on the UserForm With Comboboxes page.

Video: Golf Tee Off Template

In the video below, see how to use this Excel golf tee off times template. You can set player tee off times for golf tournaments, or for golf course daily bookings. For written steps, go to the Golf Tee Off Times Workbook page.