Your best choice is to look at the classes offered on ESRI's website. They have several (free I beleive) intro's to VBA. This is the best way to go because the actual VBA is quite easy to learn. It only becomes difficult when you start dealing with ArcObjects - the elements that allow you to customize ESRI software. The free classes are the best way to start, then move on to the higher level classes. IN college I bought the book 'Getting to know ArcObjects' which was a great start.