Collabora Office 23.05 Help
Dimensions a variable or an array at the module level (that is, not within a subroutine or function), so that the variable and the array are valid in all libraries and modules.
Public VarName[(start To end)] [As VarType][, VarName2[(start To end)] [As VarType][,...]]
Public iPublicVar As Integer
Sub ExamplePublic
iPublicVar = iPublicVar + 1
MsgBox iPublicVar
End Sub