Suffixes modify the base name of an object, indicating additional information about a variable. You’ll likely create your own suffixes that are specific to your development work. Table 4 lists some generic VBA suffixes.
Table 4. Commonly used suffixes.
Suffix |
Object Type |
|---|---|
Min |
The absolute first element in an array or other kind of list. |
First |
The first element to be used in an array or list during the current operation. |
Last |
The last element to be used in an array or list during the current operation. |
Lim |
The upper limit of elements to be used in an array or list. Lim isn’t a valid index. Generally, Lim equals Last + 1. |
Max |
The absolutely last element in an array or other kind of list. |
Cnt |
Used with database elements to indicate that the item is a Counter. Counter fields are incremented by the system and are numbers of either type Long or type ReplicationId. |
Here are some examples:
iastrNamesMin
iastrNamesMax
iaintFontSizesFirst
igphsGlyphCollectionLast
lngCustomerIdCnt
varOrderIdCnt
Copyright © 1995 Greg Reddick. You can freely distribute this document.
Related: