用于在Excel中学习VBA编程的资源（用于完整的编程新手） [英] Resources for learning VBA Programming in Excel (for a complete programming newbie)

问题描述

我的一个朋友在Excel上花了很长时间，并希望学习Excel的VBA。他没有任何经验的编码。什么是最好的资源（链接/书籍）可用？

解决方案

最好的资源是 即可。使用Excel运行它，它将生成代码来重现你刚刚完成的内容。查看并使用生成的代码是获取VBA感觉的好方法 - 语言和底层结构。

有一个很好的介绍在 http://www.mrexcel.com/articles/record-modify-run- excel-macro.php 以及有关Excel 2010的一些说明，请参阅 http：/ /msdn.microsoft.com/en-us/library/ee814737.aspx 。

Excel VBA编程傻瓜书（http://www.amazon.co.uk/Excel-VBA-Programming-Dummies-Computers/dp/0470503696/）是更好的傻瓜书之一（诚然，我读的是几年前的版本） - 作者确实知道他的东西。他还维护了一个相当不错的Excel网站，VBA部分位于 http://spreadsheetpage.com/index .php / tip / C33 。

A friend of mine spends 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.

这篇关于用于在Excel中学习VBA编程的资源（用于完整的编程新手）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！