Basics of VBA

Here is the first thing that you need to know to learn VBA:

http://en.wikipedia.org/wiki/Visual_Basic_for_Applications

Some advanced VBA codes are available on : ( I liked it very much)

http://www.cpearson.com/Excel/ExcelPages.aspx

Enjoy...