Dave Hawley's site has a good section on VBA and also have a look at Chip Pearson's and John Walkenbach's sites. I find it easier to use a book, John Walkenbach's "Excel 2002 Power Programming with VBA" is very good (and has an ad above as I'm typing this...).
Im going to get shot for this one I often have been questioned of my relationship whit Dave, hes a pal, from the world of Excel and no more [no I do not get pad to refer guys to his site or any other rubbish] OK Dave is British which kinda helps our emails when we monkey about, Dave one of the finest VBA guru I have ever seen thus why I refer to him. Another I have chatted to only a few times is Arron Blood of Xl_Logic web site.
Dave Hawley of http://www.ozgrid.com is a fine pal ive had many drinks with over the email, and so on. I only refer guys if they ask for the best to the best..
Check out the archive newsletter section now about the 15th I have been register sine before letter one, sign up Dave will email it to you about 6 – 8 of each month and always a VBA section – all wonderful stuff in simple terms good start I feel, you might ever see some Jack-i-umns. So email Dave and ask to register – worth an email very least, Tell Dave if you support HTML or need text version. No need to tell Dave I referred you – I really don’t care, just hope the information helps you that’s all.
Also see Arron site that will blow your mind – top VBA
Please don’t abuse me over this post and my friendships I have with guys around the work, im sick to death of abusive PMs and emails – all I do is help, please put your efforts into helping other, not being nasty to me, I don’t read them or really care I just delete them…