excel vba constant
' Constants are Private by default.
Const MyVar = 459
' Declare Public constant.
Public Const MyString = "HELP"
' Declare Private Integer constant.
Private Const MyInt As Integer = 5
' Declare multiple constants on same line.
Const MyStr = "Hello", MyDouble As Double = 3.4567excelvba 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
'
'
'Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
