http://vbtutor.net<--this site friendly and easy to understant vb6 (also has vba ecxel and vb2008)
http://visualbasic.freetutes.com/learn-vb6/ <---ithink is good for beginners (havent checked it yet)
https://www.youtube.com/user/Gymjunnky <--search his vids with VB6 keyword
http://visualbasic.freetutes.com/learn-vb6-advanced/ <-FOR ADVANCED