LoginSignup
0
0

More than 5 years have passed since last update.

VBA学习笔记2

Posted at

变量定义

虽然可以省略类型指定,但是容易造成变量类型前后不一的情况。
所以变量定义的时候要指定变量的类型。


例如:

Dim age as byte
Dim name as string

对象

VBA中主要有以下四种对象类型

对象对应名 对象名
应用 Application
文件所有单 Workbook
Worksheet
单元格 Range

每个对象的包含关系如下:

Application
   └ Workbooks
       └ Worksheet
           └ Range

0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0