List of VBA Data Types

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MDW - 23 Jan 2006 14:20 GMT

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.

Signature

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

Reply to this Message

Tom Ogilvy - 23 Jan 2006 14:31 GMT

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

It hasn't changed since xl97 - xl2003

Signature

Regards,
Tom Ogilvy

> 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:
[quoted text clipped - 7 lines]
>
> Thanks.

Reply to this Message

Bob Phillips - 23 Jan 2006 14:35 GMT

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

> 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:
[quoted text clipped - 9 lines]
> --
> Hmm...they have the Internet on COMPUTERS now!

Reply to this Message

Gary L Brown - 23 Jan 2006 14:46 GMT

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,

Signature

Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.

> 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:
[quoted text clipped - 7 lines]
>
> Thanks.

Reply to this Message

MDW - 23 Jan 2006 15:11 GMT

Thanks Gary. For some reason, the VBA help doesn't work on my machine.
*shakes a fist at the IT department*

Signature

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

> Data Type Bytes Vslues
> Byte 1 0 to 255
[quoted text clipped - 30 lines]
> >
> > Thanks.

Reply to this Message

Tom Ogilvy - 23 Jan 2006 15:27 GMT

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/html/v
agrpDataType.asp

Signature

Regards,
Tom Ogilvy

> Thanks Gary. For some reason, the VBA help doesn't work on my machine.
> *shakes a fist at the IT department*
[quoted text clipped - 33 lines]
> > >
> > > Thanks.

Reply to this Message