Excel VBA视频教程 课程介绍-什么是VBA

Presentation on theme: "Excel VBA视频教程 课程介绍-什么是VBA"— Presentation transcript:

1

2 Excel VBA视频教程 课程介绍-什么是VBA
Microsoft Office 3/18/2017 Excel VBA视频教程 课程介绍-什么是VBA 王佩丰 MVP 微软最有价值专家 MCT 微软认证讲师 © 2012 Microsoft Corporation. All rights reserved. Microsoft, Windows, and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

3 议程 什么是VBA 课程特点 课程大纲及学习进度安排

4 什么是VBA 概念害人 第一节什么是VBA 第二节什么是对象 第三节什么是属性 第四节什么是方法 第五节什么是事件 …………

5 课程特点 每节课“理论”与“实践”的倒置 整套视频“理论”与“实践”的倒置 Microsoft Office 3/18/2017
© 2012 Microsoft Corporation. All rights reserved. Microsoft, Windows, and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

6 课程大纲 05 操作单元格对象 课程简介：什么是VBA 06 操作单元格对象 2 01 第一次编写代码-For循环
02 IF逻辑判断 03 操作工作表 04 操作工作簿 05 操作单元格对象 06 操作单元格对象 2 07 VBA事件与典型应用案例 08 在VBA中使用公式 09 自定义函数和带参数的过程

7 课程大纲 15 使用ADO操作外部数据 10 使用DIR函数多文件合并 16 触类旁通：图形对象 11 使用数组
12 使用ActiveX控件 13 窗体与控件 14 VBA中的用户信息交互 15 使用ADO操作外部数据 16 触类旁通：图形对象 17 触“类”旁通2：类模块 18 字典与用户界面设计 19 Excel+Access系统开发

8 学习进度安排 每天学习一集 当天完成课后作业 Microsoft Office 3/18/2017
© 2012 Microsoft Corporation. All rights reserved. Microsoft, Windows, and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

9 Thank You Microsoft Office 3/18/2017
© 2012 Microsoft Corporation. All rights reserved. Microsoft, Windows, and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

10