There's a fantastic book called "Microsoft Excel 2002 Visual Basic For Applications Step by Step" available from Microsoft Press. I recommend it highly.

Mark Thorpe has a terrific, free Excel beginner tutorial series in TechTrax.
Go to the main link here:

www.mousetrax.com/techtrax

Click the link to enter the magazine itself. Then click on the ARCHIVES
button along the top menu within TechTrax and search on the term

Excel VBA

You'll get the links to the first 5 articles in his series. TechTrax is on
hiatus until Sept 1...when the new issue will be out and Mark will be back
to continue teaching. So you have about 4 weeks to study and catch up!

Oh...and...be sure to check out my book recommendation page.

www.mousetrax.com/books.html

I NEED to update it (moving closer to the top of my ToDo list<g>), but John
Walkenbach, the spreadsheet guru, has some terrific Excel VBA books. I have
his Excel 2000 Power Programming w/VBA and he's really done a great job of
covering all the basic  info, as well as the meat. I've had this book on my
shelf for years and am just NOW actually breaking it open to work with
it...and it is impressive. I have it listed on my page.

He now has the 2003 version out, which I didn't bother getting, cos' I'm
assuming it'll have a lot of the same basic info as this book...so I'll wait
until I "get it" (VBA, that is) until I deal with other version.

Oh, and John Green's VBA Programmer's reference is also another great one.
Both JWalk and John Green are long time Excel MVPs (and friends<g>), as well
as all the others who put out top Excel books like Rob Bovey (very good,
long time friend and fellow pupster fan), Stephen Bullen, Bill Manville, Tom
Ogilvy, Rob Rosenberg and, and of course, Jon Peltier...all Excel MVPs...who
have written or contributed to Excel books you can trust as being very good
resources.