Learning the Basics of Visual Basic
You can get detailed information about a keyword by selecting the word and pressing F1. For example, if you click anywhere within the keyword Sub and press F1, the Visual Basic Editor presents a Help screen containing an entry for the Sub statement. Many Help topics for VBA keywords include one or more examples of the keyword as you might use it in working code. You can copy this code, paste it into a module, and edit the resulting text to meet your needs.
Objects, Methods, and Properties
To VBA, every item in the Excel environment is an object rather than an abstract set of data structures or an arrangement of pixels on the screen. Objects can contain other objects.
At the top of the hierarchy, the largest object ...
Get Microsoft® Excel® 2010 Inside Out 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.
