List of VBA Data Types
 

Does anyone have (or know where I can locate) the list of VBA data types and
their descriptions? Really what I need is just this:

Data Type Name
Possible Values (and decimal accuracy)
Memory Usage

I've been looking on MSDN and I can't seem to find it. I need it primarily
for Office 2003, but I'd like one for Office 97 if it can be found.

Thanks.
--
Hmm...they have the Internet on COMPUTERS now!

List of VBA Data Types
 

Look up "Data Type Summary" in visual basic help in the VBE.

It hasn't changed since xl97 - xl2003

--
Regards,
Tom Ogilvy


"MDW" wrote in message
...
Does anyone have (or know where I can locate) the list of VBA data types
and
their descriptions? Really what I need is just this:

Data Type Name
Possible Values (and decimal accuracy)
Memory Usage

I've been looking on MSDN and I can't seem to find it. I need it primarily
for Office 2003, but I'd like one for Office 97 if it can be found.

Thanks.
--
Hmm...they have the Internet on COMPUTERS now!

List of VBA Data Types
 

Look at 'Type Conversion Functions' in VBA Help, this lists them all.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"MDW" wrote in message
...
Does anyone have (or know where I can locate) the list of VBA data types
and
their descriptions? Really what I need is just this:

Data Type Name
Possible Values (and decimal accuracy)
Memory Usage

I've been looking on MSDN and I can't seem to find it. I need it primarily
for Office 2003, but I'd like one for Office 97 if it can be found.

Thanks.
--
Hmm...they have the Internet on COMPUTERS now!

List of VBA Data Types
 

Data Type Bytes Vslues
Byte 1 0 to 255
boolean 2 True or False
integer 2 -32768 to 32767
long 4 -2147483648 to 2147483647
single 4 -3.402823e38 to 3.402823e38
double 8 -1.79769313486232e308 to 1.79769313486232e308
currency 8 -922337203685477.5808 to 922337203685477.5807
decimal 14 +/-79228165514264337593543950335
date 8 01/01/0100 to 12/31/9999
object 4 an object reference
string 10 bytes
+ string
length 0 to 2 billion
variant - numbers
16 a numeric value up to the rang of a double data type
variant - string
22 bytes
+ string
length 0 to 2 billion

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"MDW" wrote:

Does anyone have (or know where I can locate) the list of VBA data types and
their descriptions? Really what I need is just this:

Data Type Name
Possible Values (and decimal accuracy)
Memory Usage

I've been looking on MSDN and I can't seem to find it. I need it primarily
for Office 2003, but I'd like one for Office 97 if it can be found.

Thanks.
--
Hmm...they have the Internet on COMPUTERS now!

List of VBA Data Types
 

Thanks Gary. For some reason, the VBA help doesn't work on my machine.
*shakes a fist at the IT department*
--
Hmm...they have the Internet on COMPUTERS now!


"Gary L Brown" wrote:

Data Type Bytes Vslues
Byte 1 0 to 255
boolean 2 True or False
integer 2 -32768 to 32767
long 4 -2147483648 to 2147483647
single 4 -3.402823e38 to 3.402823e38
double 8 -1.79769313486232e308 to 1.79769313486232e308
currency 8 -922337203685477.5808 to 922337203685477.5807
decimal 14 +/-79228165514264337593543950335
date 8 01/01/0100 to 12/31/9999
object 4 an object reference
string 10 bytes
+ string
length 0 to 2 billion
variant - numbers
16 a numeric value up to the rang of a double data type
variant - string
22 bytes
+ string
length 0 to 2 billion

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"MDW" wrote:

Does anyone have (or know where I can locate) the list of VBA data types and
their descriptions? Really what I need is just this:

Data Type Name
Possible Values (and decimal accuracy)
Memory Usage

I've been looking on MSDN and I can't seem to find it. I need it primarily
for Office 2003, but I'd like one for Office 97 if it can be found.

Thanks.
--
Hmm...they have the Internet on COMPUTERS now!

List of VBA Data Types
 

http://msdn.microsoft.com/library/de...rpDataType.asp


--
Regards,
Tom Ogilvy


"MDW" wrote in message
...
Thanks Gary. For some reason, the VBA help doesn't work on my machine.
*shakes a fist at the IT department*
--
Hmm...they have the Internet on COMPUTERS now!


"Gary L Brown" wrote:

Data Type Bytes Vslues
Byte 1 0 to 255
boolean 2 True or False
integer 2 -32768 to 32767
long 4 -2147483648 to 2147483647
single 4 -3.402823e38 to 3.402823e38
double 8 -1.79769313486232e308 to 1.79769313486232e308
currency 8 -922337203685477.5808 to 922337203685477.5807
decimal 14 +/-79228165514264337593543950335
date 8 01/01/0100 to 12/31/9999
object 4 an object reference
string 10 bytes
+ string
length 0 to 2 billion
variant - numbers
16 a numeric value up to the rang of a double data
type
variant - string
22 bytes
+ string
length 0 to 2 billion

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was
this
Post Helpfull to you?''.


"MDW" wrote:

Does anyone have (or know where I can locate) the list of VBA data
types and
their descriptions? Really what I need is just this:

Data Type Name
Possible Values (and decimal accuracy)
Memory Usage

I've been looking on MSDN and I can't seem to find it. I need it
primarily
for Office 2003, but I'd like one for Office 97 if it can be found.

Thanks.
--
Hmm...they have the Internet on COMPUTERS now!