Table of contents
TOC
Collapse the table of content
Expand the table of content

Too many module-level variables

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

Module-levelvariables are those declared in the Declarations section of amodule, before the module's procedures. This error has the following cause and solution:

  • The sum of the memory requirements for all module-level variables in this module exceeds 64K.

    This is the storage limit for this module. If appropriate, you can declare some of your variables as Public in another module, or if some module-level variables are used only in one procedure, you can declare them within that procedure. If you declared variables at module level because you want them to retain their value between procedure invocations, you can instead declare them as Static within the procedure in which they are referenced.

    Note Available space can vary among operating systems.

For additional information, select the item in question and press F1 (in Windows) or HELP (on the Macintosh).

© 2018 Microsoft