Solved: How to declare public variables?

[jungix]

HI,

just a simple question. I have a module which works perfectly. However I would like to split it into several modules that I would call in turn. Like


Public Sub Main ()

dim a As
Dim b As
Dim c As
...

Call Update
Call Sort
Call Cleaning


the other modules would use a, b and c, and might modify them (in which case the next routine must use the modified value).
I need global variables for all my main. I only want to split my code to make it more readable and easier to modify it afterwards.

Is this possible?

[MWE]

HI,

just a simple question. I have a module which works perfectly. However I would like to split it into several modules that I would call in turn. Like


Public Sub Main ()

dim a As
Dim b As
Dim c As
...

Call Update
Call Sort
Call Cleaning

the other modules would use a, b and c, and might modify them (in which case the next routine must use the modified value).
I need global variables for all my main. I only want to split my code to make it more readable and easier to modify it afterwards.

Is this possible?
if I understand your question correctly, you wish to share certain variables among multiple procedures. You can declare the variables as Global before the first procedure in a given code module. Every procedure in the module can then use those variables.

[Bob Phillips]

Option Explicit

Public a As
Public b As
Public c As

Public Sub Main()
...

Call Update
Call Sort
Call Cleaning

[jungix]

Thank you!