Resources for learning VBA Programming in Excel (for a complete programming newbie) [closed]
A friend of mine sp开发者_Go百科ends long hours on Excel, and wishes to learn VBA for Excel. He has no experience coding whatsover. What are the best resources (links/books) available?
The best resource for getting going is the Macro recorder. Run it while using Excel and it will generate code to reproduce what you've just done. Looking through and playing with the generated code is a nice way of getting a feel for VBA - both the language and the underlying structures.
There's a nice introduction at http://www.mrexcel.com/articles/record-modify-run-excel-macro.php and some instructions for Excel 2010 at http://msdn.microsoft.com/en-us/library/ee814737.aspx.
The Excel VBA Programming for Dummies book (http://www.amazon.co.uk/Excel-VBA-Programming-Dummies-Computers/dp/0470503696/) is one of the better Dummies books (admittedly the version I read was a few years ago now) - the author does know his stuff. He also maintains a pretty good Excel site, the VBA section is at http://spreadsheetpage.com/index.php/tip/C33.
Pick your favorite:
http://www.excel-vba.com/excel-vba-contents.htm
http://www.vbtutor.net/VBA/vba_tutorial.html
http://www.anthony-vba.kefra.com/
Here's a similar question asked before on SO:
VBA: Basic Syntax and Examples Tutorial
And not to forget: tell him about this site, if he has specific questions, he should ask them here on SO.
精彩评论