MS-Excel / General Formatting

Creating a User-Defined Function

The Office applications come with a large number of built-in functions. Excel, for example, has hundreds of functions-one of the largest function libraries of any spreadsheet package. However, even with this vast collection, you'll still find plenty of situations that are not covered. For example, you might need to calculate the area of a circle of a given radius, or the gravitational force between two objects. You could, of course, easily calculate these things on a worksheet, but if you need such calculations frequently, it makes sense to define your own functions that you can use anytime.

[Previous] [Contents] [Next]

In this tutorial:

  1. Writing Your Own Macros
  2. Activating the Ribbon's Developer Tab
  3. Displaying the Visual Basic Editor
  4. Touring the Visual Basic Editor
  5. Understanding VBA Procedures
  6. Creating a Command Macro
  7. Entering VBA Statements
  8. Creating a User-Defined Function
  9. Understanding User-Defined Functions
  10. Writing a User-Defined Function
  11. Using a Function
  12. Advantage of VBA IntelliSense
  13. Shutting Down the Visual Basic Editor