1、宏的录制
2、表单控件(窗体)的使用
3、VBA语言(Visual Basic For Application)
选中:Range("A1:B10").select
赋值:Range("A1").value = 10
对话框:msgbox“1111” ( F1帮助)
数据类型
byte 0~255整数
boolean 保存逻辑结果:TRUE/FALSE
integer -32768~32767的整数
long 长整数
double 带小数点
date
string 字节
Variant 多变形
1、定义: dim X as string( integer....)
或者:dim X$ (各类型声明符P46)
2、定义时规定长度:dim X as string*10
3、连续定义:dim X as string, B as integer
4、强制声明所有变量:option explicit
5、公共变量:public X as string
私有变量:private X as string
静态变量:Static X as string
作用域的概念
6、本地变量,模块级变量,公共变量(P52)
7、给 “对象变量” 赋值,如单元格:
dim x as range
set x = worksheets("sheet1").range("A1")
x.value = "123"
8、声明常量:
const p as single = 3.14
9、数组:
一维:dim X (49)或者(1 to 50) as string
X(1) = "a”
二维:dim X(2, 19)或者(1 to 3, 1 to 20) as string
三维同上
动态数组: dim X() as string
redim