• Free Excel VBA Training Materials
• Excel Macros & VBA
• FREE Excel Courseware

Make a small donation to help support this site.

• Put a Permanently Open Calendar on an Excel Worksheet
  Some of my most popular tutorials involve creating calendars. This one shows you how to place an ActiveX calendar control directly on to an Excel worksheet so that it is permanently visible.
• Working Out a Person's Age - An Introduction to Nested IF Statements
  What might at first sight appear to be a simple task... you know someone's date of birth - how old are they? ...turns out to be quite a job. Here you will learn how to build a basic formula, how dates work, and how to get heavy with nested IF statements.

More Excel tutorials from my VBA section...

• Writing Your First VBA Function
  This tutorial takes you step-by-step through creating a User Defined Function (UDF) in Excel and shows you some more useful examples. A good starting point for VBA.
• More Custom Functions for Access and Excel
  If you're short of ideas for Custom Functions take a look at these. This tutorial shows you how to build and use RandomNumbers, FindSaturday, EOMonth and RemoveSpaces functions that can be used in both Excel and Access. You will also see examples of If Statements and Case Statements, and some built-in functions that you might not have discovered yet.
• An Improved Custom Random Numbers Function
  Just when you think you've thought of everything, you realise you need something else! With only minor adjustments to the original, this function allows you to specify a degree of precision (number of decimal places).
• Build an Excel Add-In
  The Add-In is an ideal tool for storing and distributing your custom functions in Excel. This tutorial is ideal for beginners, taking you step-by-step through writing a custom function, then creating and installing an Add-In. If you are already comfortable with VBA function writing, you can jump straight to the Add-In section.
• How to Use Your Excel Add-In Functions in VBA
  "I built an Add-In for my custom functions. Why why can't I use them in my workbook code?" Add-Ins are intended primarily to add extra functionality to your workbooks. If you want to be able to use their functions in your VBA code you have to set a reference to the Add-In. This article explains how.
• A Pop-up Calendar for Excel
  Entering dates correctly seems to be a problem for so many people. This tutorial shows how to create a pop-up calendar using the Microsoft ActiveX Calendar Control. Choosing a date from the calendar enters it into the active cell on the worksheet. The tutorial includes automatically assigning a keyboard shortcut, and customizing shortcut menus so that the user can right-click on a cell and ask to insert a date. There's also a ready-made Calendar Add-In to download.

Excel Questions from my Mailbag section...

• I Don't Have a Copy of the mscal.ocx Calendar Control

• How Can I Make my Excel Calendar Appear Automatically When the User Enters a Cell?

• My Excel Calendar Keeps Making Extra "Insert Date" Entries

• How can I add up just the red numbers on my worksheet?

• I've got US format dates and I can't change them with Format Cells