Hi Heath,
Besides the many options, (books, CDs, etc.) avalable from MrExcel "himself", and hanging around this board to soak up what you can, one thing you can look into is a site called VBA Express (or VBAX). They offer a real live VBA training course that is very much worth checking out.
Good luck and happy hunting.
Dan