Use a sub to change variable or constant in Module

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

Hi folks,

Is it possible to use a sub to change a module's variable
or constant?

For instant:

I have a sub called test that has variable strSalary =
1000 and Constant csName = "Tan".

I want to create another sub called test2 that can change
the variable and constant in test when it fire.

Is it possible? How?

Thanks in advance.

Tim.
 
in case your variable is declared in mobule level, or public - you can. just
assing it a new value in test2

constant - you can't change
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Constants 2
How To Programmatically Set A Procedure Name To A String Variable 2
Copying part of a header from active word document and pasting in excel using VBA 0
retaining variable values across modules 3
Change a constant? Keep a variable? 6
Using a public variable 2
Weird Behaviour of Compiler Directives? 14
Outlook Private Sub Application_Startup()....What if it be public 1

Back
Top