目录一、VBA语言基础..........................................................................................................................1第一节标识符....................................................................................................................................................1第二节运算符....................................................................................................................................................1第三节数据类型................................................................................................................................................1第四节变量与常量............................................................................................................................................1第五节数组........................................................................................................................................................2第六节注释和赋值语句....................................................................................................................................2第七节书写规范................................................................................................................................................2第八节判断语句................................................................................................................................................2第九节循环语句................................................................................................................................................3第十节其他类语句和错误语句处理................................................................................................................4第十一节过程和函数........................................................................................................................................4一.Sub过程..................................................................................................................................................4二.Function函数..........................................................................................................................................5三.Property属性过程和Event事件过程....................................................................................................5第十二节内部函数.............................................................................................................................................5一.测试函数.................................................................................................................................................5二.数学函数.................................................................................................................................................5三.字符串函数.............................................................................................................................................6四.转换函数.................................................................................................................................................6五.时间函数.................................................................................................................................................6第十三节文件操作...................................................