O'Reilly logo

A Guide to Microsoft Excel 2007 for Scientists and Engineers by Bernard Liengme

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 9

VBA User-Defined Functions

Publisher Summary

Visual Basic for Applications (VBA) is an important part of Microsoft Office. When used within Excel, it enables one to write modules that may be subroutines or functions. A function returns a value to a cell (or a range) in the same way as a worksheet function. Collectively, subroutines and functions are called modules or macros. VBA is a great way to begin. The emphasis in this chapter is on coding. To successfully code a function, two skills are needed. The first is the ability to compose, in English and mathematical symbols, the set of rules that yields the desired result. This is called the algorithm. The second is the ability to translate the algorithm into the Visual Basic language. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required