Introduction to Writing Excel Macros

You are not limited to the Built-In Functions that are provided in Excel. You can also invent your own functions by writing Excel macros to perform specific tasks.

You can even add your own macros to the Excel function menu, so that they are available to you in the same way as Excel's built-in functions.

A macro is a piece of computer code, that is written for Excel, using the Visual Basic for Applications (VBA) programming language. The basics of the VBA programming language are covered in the Excel VBA Tutorial pages of this site. However, it is recommended that you read the following sections on Excel Macro Security settings and the Visual Basic Editor, before you begin to write VBA code.

Further Information

If you want more details on writing Excel Macros the University of Durham provide an excellent Introductory Guide to Using Macros in Excel 2003.

Return to the Home Page

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2014