If you find it hard to teach yourself from a book, then MSProjectExperts provides online training delivered by Rod Gill. The course takes the format of one half day on basic VBA followed a week later by two half days on Project VBA. The book Project VBA Programming comes as part of the course and is used as the training manual.
For full details on MSProject Expert's VBA training courses visit: http://projectservertraining.com/learning/index.aspx
You get free (within reason) email support from Rod Gill for material taught on the course.
With the book, training and development services there is no reason for your project schedules and reports not to be automated and getting more done for you for far less effort.
VBA Programming
for Microsoft Office Project - The Book Project VBA development services 
Editors Gary Chefetz and Dale Howard are also Microsoft MVPs for Project
Buy VBA Programming for Microsoft Office Project
