Posted 14 October 2006 - 10:13 PM
Tools, Macros is your friend.
Start by recording macros (see Help) for few simple things like entering values, formulas, changing colors of cells or ranges of cells.
Enable your VBA toolbar (View - check Visual Basic toolbar).
Go to VBA and see what it coded for you.
Change few things. What's the effect?
Go back and forth a bit, and you'll get there quicker than reading books. That said, in my opinion nothing beats O'Reilly books or Microsoft's own.
VBA has Help screens (press F1 over any keyword).
Once you get the drift, next step is to quickly get away from the way VBA codes exact cell addresses and move on to being able to do what you code anyplace, anysheet, any workbook.