Excel Programming through VBA: A Complete Macro Driven Excel 2010 Application

Excel Programming through VBA: A Complete Macro Driven Excel 2010 Application

After completing this EBook you will have a complete, macro driven, Excel application. The original version is Excel 2010, but the code and functionality is designed to work on previous versions; in addition to the 2013 version. All source code and Excel sheets are downloadable from the author's web site.
We will cover the following subjects.

1. Using the Match statement




2. Creating a user interface with UserForms




3. Loading web addresses from your Excel application




4. Programming Excel through VBA-based subroutines




5. Creating button functionality through code




6. Populating form elements with values in your Excel sheet