Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
declaring Excel constants
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
declaring Excel constants
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) "RB Smissaert" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
declaring Excel constants
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 "Bob Phillips" wrote in message ... 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) "RB Smissaert" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
declaring Excel constants
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 "RB Smissaert" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Constants in Excel | Excel Discussion (Misc queries) | |||
vba constants for excel | Excel Discussion (Misc queries) | |||
Declaring Constants that can be used throughout the Workbook :) | Excel Programming | |||
Declaring array constants at module level | Excel Programming | |||
declaring constants from the sheet? | Excel Programming |