Getting Started with macros and VBA for Excel (ii)-Basics

I. Properties and Methods

　　1. Properties

　　　　Click on the object above and the corresponding property is displayed below:

　　　　

　　2. Methods

　　　　Double-click the upper-left object to see the appropriate method:

　　　　

ii. Types of data

Byte    0To255Boolean    TrueOrFalseInteger- +,768To +,767Long(Long integer type)-2,147,483,648To2,147,483,647 Single(single-precision floating-point type)Double(double-precision floating-point type) CurrencyDecimal    Date     -Years1Month1Day to9999Years AMonth toDayObjectAnyObjectReferencesStringVariant (number) -Bytes Any numeric value, maximum up toDoublethe range variant (character) ABytes plus string length and variable lengthsStringthere is the same scope for users to customize all elements required the range of each element is the same as the range of its own data type. (using Type)

Third, variable

Getting Started with macros and VBA for Excel (ii)-Basics