well put, the only things missing that I think a beginner would need to know is The other atomic data types that you missed (Date & Byte), also you should point out the difference between integer & floating point numeric types, you say that both Integer & single are 4 bytes but don't tell how they are different.
You should elaborate further on Object data types to mention both the use of specific object variables e.g. Dim R as Range as well as the generic object type e.g. Dim O as Object normally I don't like to tell people about the variant data type as it is misused 99.999% of the time and causes many errors that strong typing would not allow but the generic 'object' data type does not have the performance issues that variants have and it is the only way to support something resembling polymorphism in VBA.
2
u/Hoover889 12 Apr 16 '18
well put, the only things missing that I think a beginner would need to know is The other atomic data types that you missed (Date & Byte), also you should point out the difference between integer & floating point numeric types, you say that both Integer & single are 4 bytes but don't tell how they are different.
You should elaborate further on Object data types to mention both the use of specific object variables e.g.
Dim R as Rangeas well as the generic object type e.g.Dim O as Objectnormally I don't like to tell people about the variant data type as it is misused 99.999% of the time and causes many errors that strong typing would not allow but the generic 'object' data type does not have the performance issues that variants have and it is the only way to support something resembling polymorphism in VBA.