开发者

Resources for learning VBA Programming in Excel (for a complete programming newbie) [closed]

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 10 years ago.

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜