Steven Bright 
Excel VBA Programming [EPUB ebook] 
Automating Excel through Visual Basic for Application

Most of the procedures and tasks in Microsoft Excel can be Automated through the use of Visual Basic Application (VBA) Excel Programming. This Book deals with the fundamentals of VBA Excel Programming and how to create Excel Add-Ins. These are what you will learn:
'Introduction to Visual Basic For Application (VBA) .
*Visual Basic Application (VBA) For Excel Basics.
*Rules for Naming Procedures
*VBA Macro Code
*VBA Excel Object
*Arrays
*Sub, Event and Function Procedures
*User Form and Button Procedure VBA Codes
*Essentials of Visual Basic Programming.
*Function
*Worksheet Function
*How to Create Excel Add-Ins