As resident techie I have been charged with teaching some colleagues VB specifically for use with Excel.
My main duties involve MySQL and Objective-C and haven't touched VB since University. While I'm not worried about the prospect of learning VB (how hard can it be, right?). I have no clue on where to point my "students" to start.
Any good books? Online tutorials? I will of-course be sending them to SO.
About.com often has good stuff.
After that maybe some Free VBA Tutorials
Google search came up with - http://www.vbtutor.net/VBA/vba%5Ftutorial.html this one is very basic and probably you will just have to breeze thru it and then probably move on to my personal favorite www.ozgrid.com
I like VBA Developer's Handbook by Getz and Gilbert for a book. On the internets, I always wind up at ozgrid.com and cpearson.com.