Recommended VBA Classes or books

[Ennovi]

Hi Everyone,

I've been doing a little research but haven't really seen anything on this so any help would be greatly appreciated.

I was recently given the task to learn VBA, I'm fairly confident in Excel but VBA is new to me. My question to you is are there any books aside from the Mr. Excel and John Walkenbach ones that you would recommend (I found those being suggested here a lot). Also if there are any classes anyone's ever taken and found beneficial please let me know. I'm in Chicago if that helps.

Thanks!

 

[VoG]

Hello Ivonne and welcome

This question must have been asked a thousand times but if you are new to programming and if $25 won't break the bank then http://www.add-ins.com/vbhelp.htm

Having done that, hang about here - you can learn loads just by following the posts.

 

[Richard Schollar]

Hi Ivonne

Not a book and it is by Bill Jelen (well, co-authored):

2500 VBA Samples

Part of the problem with learning from a book is 1) getting the information to truly sink in and 2) applying what you learn to a real world example. The above helps with this because you can read what the code does and then copy and paste the code into one of your workbooks and try running it there and then. Stepping thru it in the VBE so you see exactly what it is doing line by line will help tremendously.

Ultimately, the best way I have found to learn is to identify a need you have (eg at work you need to automate some process) and work on solving that need thru VBA. The 2500 code examples can give you an idea and you can flesh out the exact implementation with the help of the Board and your own reserach eg books, as you have mentioned.