Standard VB is pretty straightforward if you've ever done any programming. It starts getting "fun" when you have to call Excel functions, or DB functions or API functions, although all of that is much easier now in .net.
SAMS do a good range of books, but really if you understand logic (if then, for next, select case, while wend, etc) then you only really need a reference book.
Good luck.

Ta-ra