VBA语言规范之变量生命周期类型（Extent Name - VBA Language Specification）

最新推荐文章于 2020-12-14 16:55:57 发布

预见未来to50

最新推荐文章于 2020-12-14 16:55:57 发布

阅读量581

点赞数

分类专栏：数据分析（Data Analysis） Excel技巧及VBA编程（Excel_VBA）

本文链接：https://blog.csdn.net/hpdlzu80100/article/details/80664846

版权

422 篇文章 39 订阅

订阅专栏

404 篇文章 169 订阅

订阅专栏

变量生命周期即变量在内存中与数据值绑定的时间跨度。

变量生命周期类型（Extent Name）	变量声明方式（Variable Definition Form）	变量生命周期（Variable Lifespan）
Program Extent	Defined by the VBA specification or by the host application.	The entire existence of an active VBA Environment.
Module Extent	A Module Variable Declaration or a static local variable declaration within a procedure.	The span from the point that the containing module is incorporated into an active VBA project to the point when the module or project is explicitly or implicitly removed from its VBA Environment.
Procedure Extent	A procedure local variable or formal parameter declaration of a procedure.	The duration of a particular procedure invocation.
Object Extent	A variable declaration within a class module.	The lifespan of the containing object.
Aggregate Extent	A dependent variable (section 2.3.1) of an array or UDT variable.	The lifespan of the variable holding the containing aggregate data value (section 2.1.1).