Search:

MS Office Answers

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question Asked By: Magenta Ricci on Nov 02 In MS Office Category.

how to preserve variable value between subroutine calls?

Question Answered By: Kiet Jainukul on Nov 02

If you use Static instead of Dim when you declare the variable in your sub,
the value is retained while the workbook is open. It is not visible to other
subs and is destroyed when the workbook is closed.

This Question has 9 more answer(s). View Complete Question Thread

Didn't find what you were looking for? Find more on how to preserve variable value between subroutine calls? Or get search suggestion and latest updates.

Related Topics:

Problem Executing Subroutine
Trying to use Worksheet_Change subroutine
GOBACK subroutine
vba question, subroutine
Assemble Language Subroutine
defining subroutine in the main program
Help with Value in a Variable
Question on variable values carrying from UserForm1 to Module1
multiplying two integer variables and assigning to a long variable
what is instance variable and class variable.
What variables are in heap and what variables are in stack
Calling a value from a different tab
Sort where a selected cell is preserved
VBA to Change value in column AQ based on values in I, and AI
Looping thru values to match w/ other values
Matching date values w/ dropdown values
Using Excel workbook as a subroutine to a separate executable?
Object variable or With block variable not set error?
how to concatenate string variables
Public variables

Tagged:how to preserve variable value between subroutine calls

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us