By using shortcut.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

73 Shortcuts for Excel



Shortcut - Public


VBA statement to tell VBA that the variable, sub or function to follow is a global variable.

That means it can be used or changed anywhere in the program.

Using this can make it harder to find bugs, but easier to code.

A common agreed to naming convention is to start all public variables with a "g" for global.

Explain VBA Global Variables
VBA Global Variables Video

    Table of Contents | Send us your feedback | Random | © 2025 All Rights Reserved | Edit