A lot of material is available on the web and books to answer your
questions. Still, David has provided enough info to get you started.
I am listing below 2 well written books by John Walkenbach, the Excel guru:
Excel VBA Programming For Dummies
Excel 2003 Power Programming With VBA
You may also look up sites like MrExcel.com
And, writing small programs in VBA will help..