Resources for learning VBA programming in Excel (for a complete programming novice)

Question

My friend spends long hours in Excel and wants to learn VBA for Excel. He has no coding experience. What are the best resources (links / books)?

Answer 1

The best resource to go is the Macro recorder . Run it using Excel and it will generate code to reproduce what you just did. Looking through and playing with the generated code is a good way to get a feel for VBA - both the language and the underlying structures.

http://www.mrexcel.com/articles/record-modify-run-excel-macro.php Excel 2010 http://msdn.microsoft.com/en-us/library/ee814737.aspx.

Excel VBA Programming for Dummies (http://www.amazon.co.uk/Excel-VBA-Programming-Dummies-Computers/dp/0470503696/) (, , , ) - . Excel, VBA http://spreadsheetpage.com/index.php/tip/C33.

Answer 2

:

http://www.excel-vba.com/excel-vba-contents.htm

http://www.vbtutor.net/VBA/vba_tutorial.html

http://www.anthony-vba.kefra.com/

, SO:

VBA:

: , , , SO.