chen li wrote:

> Hi all,
> 
> Dim in VBA is a key word used to define variable. But
> what does it stand for? For example
> 
> Dim varCopy As Long

http://en.wikipedia.org/wiki/BASIC

"In some dialects, variables must be declared (using the DIM statement) on
their first usage; ..."

Basically, in VBA, "dim" causes a variable to be declared and associated
with a predefined data type or class.

Some advice from an experienced programmer. Avoid too much immersion in VBA.
Microsoft is notorious for serial abandonment of its proprietary user-level
languages in its effort to get you to move on to their latest fad, all in
the name of continued corporate profitability.

-- 
Paul Lutus
http://www.arachnoid.com