免费下载-分享--Excel VBA 应用教程—
目 录
一、 VBA 语言基础 ...................................................................................................................1
第一节 标识符 ............................................................................................................................... .....1
第二节 运算符 ............................................................................................................................... .....1
第三节 数据类型 ............................................................................................................................... .1
第四节 变量与常量 ............................................................................................................................1
第五节 数组 ............................................................................................................................... .........2
第六节 注释和赋值语句 ....................................................................................................................2
第七节 书写规范 ............................................................................................................................... .2
第八节 判断语句 ............................................................................................................................... .2
第九节 循环语句 ............................................................................................................................... .3
第十节 其他类语句和错误语句处理 ................................................................................................4
第十一节 过程和函数 ........................................................................................................................4
一． Sub 过程 ........................................................ ......... 4
二． Function 函数 ................................................... ......... 5
三． Property 属性过程和 Event 事件过程 ....................................... .. 5
第十二节内部函数 .............................................................................................................................5
一．测试函数 ......................................................... ....... 5
二．数学函数 ......................................................... ....... 5
三．字符串函数 ........................................................ ...... 5
四．转换函数 ......................................................... ....... 6
五．时间函数 ......................................................... ....... 6
第十三节 文件操作 ............................................................................................................................6
文件 ............................................................. ........... 6
删除 ............................................................. ........... 6
打开 ............................................................. ........... 6
读入 ............................................................. ........... 7
写入 ............................................................. ........... 7
关闭 ............................................................. ........... 7
其他文件函数 ......................................................... ....... 7
二、 VISUAL BASIC 程序设计网络教学 .....................................................................................1
第一课 VBA 是什么 .................................................................................................................1
1.1 VBA 是什么 ............................................................................................................................... .....1
1.2 EXCEL 环境中基于应用程序自动化的优点 ................................................................................1
1.3 录制简单的宏 ..............................................................................................................................1
1.4 执行宏 ............................................................................................................................... ...........2
1.5 查看录制的代码 ..........................................................................................................................2
1.6 编辑录制的代码 ..........................................................................................................................3
1.7 录制宏的局限性 ..........................................................................................................................3
1.8 小结 ............................................................................................................................... ...............3
第二课 处理录制的宏 ............................................................................................................3
2.1 为宏指定快捷键 ..........................................................................................................................3
2.2 决定宏保存的位置 ......................................................................................................................4
2.3 个人宏工作簿 ..............................................................................................................................4
2.3.1 保存宏到个人宏工作簿 ............................................... ... 4
2.3.2 使用并编辑个人宏工作簿中的宏 .......................................... 4
2.4 将宏指定给按钮 ..........................................................................................................................4
2.5 将宏指定给图片或其他对象 ......................................................................................................5
2.6 小结 ............................................................................................................................... ...............5
第三课 学习控件 ...................................................................................................................5
剩余63页未读，继续阅读
资源评论
