VBA (Excel VBA, Access VBA, Word VBA, Outllook VBA, Power Point VBA, MS Project VBA) defined two types of string data type, Fixed string and Variable string.
Fixed String:
- Length is fixed, data beyond that limit will be truncated.
- Memory will be blank, in case of number of character is less than the maximum length.
Variable String:
- Length will be varied depends on the data length.
- Allocated only as much as memory based on the data length.