Value Types

BooleanThe boolean data type can contain either the value True or False.
ByteThe byte data type can contain any positive number between 0 and 255.
CurrencyThe currency data type can store numbers in the range from -922,337,203,477.5808 (-9.22 E14) to 922,337,203,685,477.5807 (+9.22 E14)
DateThe date data type can hold any date in the range 1 Jan 0100 to 31 Dec 1999
DoubleThis is short for double precision floating point
IntegerThe integer data type can contain any number between -32,768 and 32,767
LongThe long data type can contain any number between -2,147,483,648 ans 2,147,486,647
LongLongThe longlong data type can contain any (64 bit only) number
LongPtrThis was added in Office 2010 (VBA 7.0)
SingleThis is short for single precision floating point
StringThe string data type can contain any sequence of characters
EnumerationsAn enumeration is a way of grouping symbolic constants into a single category.

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext