Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Resetting Global Variables

Status
Not open for further replies.
Krusher

Krusher

IS-IT--Management
Jan 2, 2003
70
0
0
US
How can I reset public variables? Or, how do I simply tell VBA to "recompile" everytime the user executes the macro? Thanks in advance.

K
 
Sort by date Sort by votes


Hi,

Write a procedure that initializes the variables in question. Then call this procedure any time you want them "reset".

Skip,
[sup][glasses]Don't let the Diatribe...
talk you to death![tongue][/sup][sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Question
VB Excel - Global Macro run when columns are added / removed
Replies
1
Views
29
combo
combo
LorenUCT
  • Locked
  • Question
Resetting Userform Default Text Value Via VBA
Replies
8
Views
105
LorenUCT
LorenUCT
Fbobak
  • Locked
  • Question
VBA Code for Access reports using variables
2
Replies
23
Views
135
Fbobak
Fbobak
SnayJ
  • Locked
  • Question
Cleaning up code, declaration and assignment of variables on same line...
Replies
14
Views
77
SnayJ
SnayJ
grnzbra
  • Locked
  • Question
Global Variable in Excel 1
Replies
5
Views
31
grnzbra
grnzbra

Part and Inventory Search

Sponsor

Back
Top