[NB: The promised diagrammatic explanation (from last week's tutorial) of the ExcelVB code for launching a URL in a browser will be sent to you during the week]<\/p>\n
\u00a0<\/p>\n
This week I feature an article published by Microsoft to introduce ExcelVB. Note that even though the title specifies Excel 2010, most of what is discussed applies to Excel 2007 upwards.<\/p>\n
\u00a0<\/p>\n
I encourage you to read it from start to end and print it out if you can - because it provides a useful foundation of understanding on which you can build your ExcelVB expertise over time.<\/p>\n
\u00a0<\/p>\n
\u00a0<\/p>\n
Summary:<\/p>\n
\u00a0<\/p>\n
Introduces Visual Basic for Applications (VBA) in Excel 2010 to the Excel power user who is not yet a programmer.<\/p>\n
\u00a0<\/p>\n
This article includes an overview of the VBA language, instructions on how to access VBA in Excel 2010, a detailed explanation of a solution to a real-world Excel VBA programming problem, and tips on programming and debugging. (14 printed pages)<\/p>\n
\u00a0<\/p>\n
Last modified: December 11, 2009<\/p>\n
\u00a0<\/p>\n
Ben Chinowsky, SDK Bridge<\/p>\n
\u00a0<\/p>\n
In this article:<\/p>\n
\u00a0<\/p>\n
1. Why Use VBA in Excel 2010?<\/p>\n
\u00a0<\/p>\n
2. VBA Programming 101<\/p>\n
\u00a0<\/p>\n
3. Macros and the Visual Basic Editor<\/p>\n
\u00a0<\/p>\n
4. A Real-World Example<\/p>\n
\u00a0<\/p>\n
5. Modifying the Recorded Code<\/p>\n
\u00a0<\/p>\n
6. More Things that You Can Do with VBA<\/p>\n
\u00a0<\/p>\n
7. What's Next?<\/p>\n
\u00a0<\/p>\n