Best way to declare variables for use in all modules?

[JumboCactuar]

Hi,
As title, I'm unsure of the correct way to do this as I've seen a few ways.

On workbook open ?
Public / Const?

Example:
myVar1 = Sheets("Sheet1").Range("A1").value

How can I use myVar1 in all macros without any further declaration

Any info appreciated

 

[Yongle]

Declare in a standard module

Public myVar1 As String

Use the appropriate variable type

 

[JumboCactuar]

Declare in a standard module

Public myVar1 As String

Use the appropriate variable type

Thanks
So I can create 1 module and name it myVariables

Then store all in here?
Example

Module Name: myVariables

public myVar1 as integer, myVar2 as integer

myVar1 = 1
myVar2 = 1

Module1

Private Sub Test1()
Sheets("Data").Range("A1") = myVar2
End Sub

 

[Yongle]

Is it a variable that will change or a constant value?

 

[JumboCactuar]

Will change but question was aimed at constant variables also

 

[RoryA]

constant variables

It's one or the other, not both.

 

[Yongle]

Declare at top of standard module above all procedures

Public Const TaxRate = 0.2
Public myVar1 As Integer

And use in any procedure in any module in the workbook

See this tutorial
https://powerspreadsheets.com/declare-variables-vba-excel/

 

[JumboCactuar]

Declare at top of standard module above all procedures

Public Const TaxRate = 0.2
Public myVar1 As Integer

And use in any procedure in any module in the workbook

See this tutorial
https://powerspreadsheets.com/declare-variables-vba-excel/

Thank you
The page has some good info,
Didn't know about type declaration characters

 

[Yongle]

Thanks for feedback