declaring Excel constants

  • Thread starter Thread starter RB Smissaert
  • Start date Start date
R

RB Smissaert

For a VB6 ActiveX dll I had to declare some xl Constants.
Does it matter which of the following 3 ways you choose?

Const xlUp as long = -4162
Const xlUp as Integer = -4162
Const xlUp = -4162

It looks the datatype is Integer but I am not sure.

RBS
 
It doesn't matter, but declaring as Long is the most efficient. Integers
could cause a problem if you try and load a too large value in them. Long is
safe and fully typed.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
OK, I thought that was the best option but thanks for making it clear.
Just one thing there is the file XL97CONS.BAS on one of the MS sites
and that doesn't set the datatype. Any idea why that is?

RBS
 
All the Excel constants are declared as Longs (Enums) in the
Excel typelib, so go with As Long.


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