Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I hide unused file types from file types list in save dial | Excel Discussion (Misc queries) | |||
Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" | Charts and Charting in Excel | |||
Data types when importing Excel data to SQLServer | Excel Discussion (Misc queries) | |||
date data types | Excel Programming | |||
Test for 3 types of data | Excel Programming |