Reddit mentions of Excel 2013 Power Programming with VBA

I highly recommend Excel 2013 Power Programming with VBA. Newer versions have a different author, who I'm not familiar with. Walkenbach was pretty damn good with what he covered and how he covered it.

The two I keep on my desk:

Excel 2013 Power Programming with VBA by John Walkenbach

Professional Excel Development by Rob Bovey

The second one is more advanced, but indispensable if you want professional quality applications in VBA.

So, here's my advice and basically how I learned what I did. I got a major in Finance in college, but I took Python and C++ classes (I also took a discrete class and an "IT" class that gave me some additional insight, but probably unnecessary). With that being said, I would learn basic Python first because debugging and learning algorithms is an absolute bitch in VBA. You don't need to learn additional libraries etc, just go through a basic online course and get through learning about Object Oriented Programming. From there it is much easier to transfer to VBA and learn the Excel object library. This guy: http://amzn.com/1118490398 is the best VBA programmer and is very well known. I mainly use the book as a reference when I'm going into an entirely new area and I search google for smaller questions Also, stop by /r/excel and feel free to PM me with any additional questions!

I actually just bought this book:
http://www.amazon.com/gp/product/1118490398/ref=ox_sc_act_title_1?ie=UTF8&psc=1&smid=ATVPDKIKX0DER

Thank you! I used John Walkenbach's book on VBA programming. The click buttons are called Form Controls, and they link to macros that execute VBA code. It's pretty easy to pick up as there are lots of online examples.

http://www.amazon.co.uk/Excel-Power-Programming-Spreadsheets-Bookshelf/dp/1118490398/ref=sr_1_1?s=books&ie=UTF8&qid=1412752286&sr=1-1&keywords=john+walkenbach

Excel 2013 Power Programming with VBA

There won't be any mandatory books for the course, but I will put on the syllabus that a good reference is John Walkenbach's "Excel 2013 Power Programming with VBA". I think this book is better for people who already have some experience in VBA since it is very thick an intimidating to the beginning.

http://www.amazon.com/Excel-2013-Power-Programming-VBA/dp/1118490398

I second the need for Excel and VBA. Then pick up more depending on what you actually end up doing. I advanced up the pay ladder by learning Access & SQL. VBA Resource I agree with your sentiment to just pick a project and start programming. I learned more from trial and error and stackoverflow threads than I did in any tutorial class or reference book.

As long as you understand that VBA would be less efficient, and you'd be doing it for the experience.

I like to get fully immersed in topics so I'd recommend this book. It helped me get a solid introduction of most topics without getting too complex. You can get by with just googling functions but long term you'll want a more thorough introduction either with this book or an online resource. Also the contextuals (spelling?) and mrexcel sites are good iirc. And definitely stackoverflow.

With that being said, this is a pretty straight forward script, so it shouldn't give you that much trouble. If you have trouble feel free to post your sample script and I can make some suggestions. The best method to learning VBA is to just go at it and see what work. Google and stackoverflow are your friend.