To make certain that you declared your variables, place Option Explicit in your Declarations section. Using a mixture of upper and lower case in variable names, you can easily verify that you don’t misspell variable names as you type them. By entering the names in all lower or upper case, the editor changes the variables’ appearance automatically to match the declared syntax:
Public strFetchThis as StringPublic iCountMe as Integer
When you declare these variables, typing STRFETCHTHIS or icountme results in the editor’s changing them to the declared appearance when you move on.