Warning: Use of undefined constant style - assumed 'style' (this will throw an Error in a future version of PHP) in /home1/tayoswdg/public_html/sdnuggets/wp-content/themes/ThrillingTheme0/functions.php on line 522
807 views

[Featured Article] Getting Started with VBA in Excel 2010 – from msdn.microsoft.com

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

 


Warning: count(): Parameter must be an array or an object that implements Countable in /home1/tayoswdg/public_html/sdnuggets/wp-includes/class-wp-comment-query.php on line 399

Leave a Comment Here's Your Chance to Be Heard!

You must be logged in to post a comment.