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. ...
Get A Guide to Microsoft Excel 2007 for Scientists and Engineers now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
