Constant definition

[Guest]

The constants such as xlcopy, xlpaste, etc. I understand. However, in trying
to define what a constant is, I'm not as clear.

Is a constant an application (Excel) property? I'm struggling a bit with
properties, objects, etc.

 

[Tom Ogilvy]

Look in the object browser.

Excel.xlcutcopymode.xlcopy

Library: Excel
Class: xlcutcopymode
Member: xlcopy

I suspose you could call it a property.

demo's from the immediate window:

? Excel.xlcutcopymode.xlcopy
1

 

[Chip Pearson]

A constant is nothing more than a name for a number. Constants
are grouped together in related groups called Enums. For example,
the XLWindowState enum contains three member constants:
xlMaximized, xlMinimized, xlNormal. Each of these has a numeric
value, of data type Long.

Constants are not properties.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Tom Ogilvy]

Chip is absolutely correct. If you thought of them as procedures, it could
"stunt your growth" so to speak - so I was wrong in saying that. You can
also have your own Enums in excel 2000 and later (VBA 6).

Just a slight addendum

A constant is nothing more than a name for a number.

Just to clarify, a constant doesn't have to be a number; example exceptions
such as vbnullstring, vbnullchar and vbBack, part of the Enum vbConstants

And Chip and I have largely been describing intrinsic constants, not all
constants.

Microsoft Excel supports three types of constants:

· Symbolic constants, which you create by using the Const statement and use
in modules.
· Intrinsic constants, which are part of Microsoft Excel/VBA or a referenced
library.
· System-defined constants: True, False, and Null.

--
Regards.
Tom Ogilvy

A constant is nothing more than a name for a number. Constants
are grouped together in related groups called Enums. For example,
the XLWindowState enum contains three member constants:
xlMaximized, xlMinimized, xlNormal. Each of these has a numeric
value, of data type Long.

Constants are not properties.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Guest]

THANK YOU to both of you for clarifying this. It's all quite overwhelming
for a newbie.

Chip is absolutely correct. If you thought of them as procedures, it could
"stunt your growth" so to speak - so I was wrong in saying that. You can
also have your own Enums in excel 2000 and later (VBA 6).

Just a slight addendum

A constant is nothing more than a name for a number.

Just to clarify, a constant doesn't have to be a number; example exceptions
such as vbnullstring, vbnullchar and vbBack, part of the Enum vbConstants

And Chip and I have largely been describing intrinsic constants, not all
constants.

Microsoft Excel supports three types of constants:

· Symbolic constants, which you create by using the Const statement and use
in modules.
· Intrinsic constants, which are part of Microsoft Excel/VBA or a referenced
library.
· System-defined constants: True, False, and Null.