Microsoft Office Tutorials and References
In Depth Information
Chapter 24: VBA Programming Concepts
24
VBA Programming
Concepts
In This Chapter
Introducing an example Function procedure
Using comments in your code
Understanding VBA’s language elements, including variables, data types, and constants
Using assignment expressions in your code
Declaring arrays and multidimensional arrays
Using the built-in VBA functions
Controlling the execution of your Function procedures
Using ranges in your code
This chapter discusses some of the key language elements and programming concepts in VBA. If
you’ve used other programming languages, much of this information may sound familiar. VBA
has a few unique wrinkles, however, so even experienced programmers may find some new
information.
This chapter does not even come close to being a comprehensive guide to VBA. Motivated
readers can consult the Help system and make use of Internet resources or other books for additional
information.
Many of the code examples in this chapter are on the companion CD-ROM. The file is
named function examples.xlsm .
 
Search JabSto ::




Custom Search