[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]

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.

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.

<h3>Getting Started with VBA in Excel 2010 | Office 2010</h3>

Summary:

Introduces Visual Basic for Applications (VBA) in Excel 2010 to the Excel power user who is not yet a programmer.

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)

Last modified: December 11, 2009

Ben Chinowsky, SDK Bridge

In this article:

1. Why Use VBA in Excel 2010?

2. VBA Programming 101

3. Macros and the Visual Basic Editor

4. A Real-World Example

5. Modifying the Recorded Code

6. More Things that You Can Do with VBA

7. What’s Next?

<a href=”https://msdn.microsoft.com/en-us/library/office/ee814737(v=office.14).aspx” target=”blank”>Continue reading</a>