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