excelvba declare global constant

'In VBA, GLOBAL variables must be declared ABOVE all procedures in a module:

Public MyGlobalString As String				'<-- global to ALL modules
Private MyGlobalLong As Long				'<-- global to THIS module (Private)
Public Const HELP As String = "Press F1"	'<-- global to ALL modules

Sub Add(a, b)
	MyGlobalLong = a + b
End Sub

Call Add(7, 2)			
MsgBox MyGlobalLong		'<--displays: 9
MsgBox Help				'<--displays: Press F1

'
'
'

Add Own solution

Log in, to leave a comment

Are there any code examples left?

Find Add Code snippet

New code examples in category VBA

VBA 2022-03-27 20:55:02 excel vba check if all substrings in list are in string
VBA 2022-03-27 20:40:39 excel vba set cell value to empty
VBA 2022-03-27 17:05:52 vba simple quote
VBA 2022-03-27 14:30:19 textbox find and replace vb
VBA 2022-03-27 09:10:21 nested if else in vb.net
VBA 2022-03-27 09:10:09 excel vba string to bits
VBA 2022-03-25 02:00:15 vba verticalalignment
VBA 2022-03-24 12:20:06 Excel web scraping
VBA 2022-03-24 10:11:00 excel vba BitToLong
VBA 2022-03-21 18:00:05 excel vba save file txt

Create a Free Account

Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.

Develop soft skills on BrainApps

Complete the IQ Test

Relative searches

vba globale variable excel vba how to set global variable initialize global variable vba visual basic excel global variables excel vba how to use global variable excel vba global variable set value What are global variables in vba vba excel variable globale excel vba how to set global variables declaring global variables in vba global variable worksheet vba variable global vba vba excel global variable initialization vba global variables in module excel vba global function excel vba set global variable excel vba initialize global variable excel vba make global variable vba set global variable value vba use global variables access vba develop a global variable Global Variables VBA excel global variable in vba excel declare global variable in vba vba declare constant excel loop through global variable excel global variables constant vba excel vba constant how to declare constant global variables using vba how to store global variables using vba excel declare constant vba store global variable xl-vba global vs public xl vba global vs public xlvba global vs public excelvba global vs public excel vba global vs public vba global vs public vba declare globals excelvba declare globals excel vba declare globals xl vba declare globals xl-vba declare globals xlvba declare globals xlvba declare global constant xl-vba declare global constant excel-vba declare global constant excel vba declare global constant excelvba declare global constant vba declare global constant vba declare global variables vba declare global variable vba set global variables variable global macro excel how to make a variable visible to all sub and functions in vba global variable in vba how to make a variable global in excelvba global variables excel vba class global variable vba excel global module excel macro global variable vba global variables excel vba global variable initialize declare global variable vba pass a global variable vba outlook module global variable vba using global var vba excel global var vba vba excel global variable vab global variable Set global vba how dim a variable global excel vba global variable use global variable from another module vba excel vba dim global variable global variable vba global variables vba global variables in vba vba overwrite global variable vba global variable vba excel global variables vba how to declare a global variable excel vba how to declare a global variable

Made with love

Welcome Back!

Sign up to unlock all of IQCode features:

Test your skills and track progress
Engage in comprehensive interactive courses
Commit to daily skill-enhancing challenges
Solve practical, real-world issues
Share your insights and learnings

Create an account

Create a Free Account

Sign up to unlock all of IQCode features:

Test your skills and track progress
Engage in comprehensive interactive courses
Commit to daily skill-enhancing challenges
Solve practical, real-world issues
Share your insights and learnings

Create an account

Creating a new code example