Calling a variable from outside module (VBA)

Question

Is there a clever way of storing variables globally so that you can call them at any of the modules at anytime?

Example

Dim pwd As String pwd = "password" Private Sub Test() MsgBox (pwd) End Sub

Thanks

ComputerVersteher · Accepted Answer · 2018-08-22 22:42:40Z

2

Your example is a constant.

Public Const pwd as String = "password"

Declare it on top of a standard module.

For other solutions with subs, functions or properties look at the Related-Section on the right side of the page.

answered Aug 22, 2018 at 22:42

ComputerVersteher

2,6941 gold badge12 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Oday Salim Over a year ago

I intend to manipulate it in one or more of the functions in the module. Is constant viable?

ComputerVersteher Over a year ago

@OdaySalim a constant is constant ;) Not changeable! I would suggest a property. See answer of Mathieu and have a look at the other related questions as I told you.

ni37osllb · Accepted Answer · 2018-08-22 20:49:38Z

0

Global pwd As String

inside of a module-level module (not a sheet-level module).

answered Aug 22, 2018 at 20:49

ni37osllb

921 gold badge1 silver badge9 bronze badges

Collectives™ on Stack Overflow

Calling a variable from outside module (VBA)

2 Answers 2

2 Comments

Comments

Linked

Hot Network Questions