[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.
Getting Started with VBA in Excel 2010 | Office 2010
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?
You’re reading [Featured Article] Getting Started with VBA in Excel 2010 – from msdn.microsoft.com by Tayo Solagbade, originally posted on his Daily Self-Development (SD) Nuggets™ blog. If you loved reading this post, be sure to follow Tayo on Twitter, Facebook, and Google+.
On 4th May 2014, Tayo’s 9 year old domain (Spontaneousdevelopment dot com), was taken over by Aplus.net. Within a few days however, Tayo used his advanced self-taught web development skills to build (and move his website contents into) a SUPERIOR “reincarnation” at http://www.tayosolagbade.com.
Most URLs bearing the old domain name appearing in search engines should now work if “spontaneousdevelopment.com” is replaced with “tayosolagbade.com”. If you experience any difficulties finding a page or document, email Tayo at tksola dot com.
Click “Tayo, What Happened to SpontaneousDevelopmentDotCom?” to read a detailed narrative about how the above event occurred :-))
Here’s an article Tayo wrote, to inspire others to defy adversity, and bounce back to even greater reckoning at what they do EVERY time:
Succeed by Emerging from Adversity Like a Phoenix (TayoSolagbade.com launches extra Hosting plan with FREE Web Marketing!)
And he wrote the one below, to explain why losing a domain name, no matter how old NO LONGER determines your online success or otherwise: