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.

Using the Match statement

Creating a user interface with UserForms

Loading web addresses from your Excel application

Programming Excel through VBA-based subroutines

Creating button functionality through code

Populating form elements with values in your Excel sheet