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!

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

resetting all variables

Status
Not open for further replies.

ChrisParks

Technical User
Feb 27, 2007
10
US
is there a single statement that resets all of the values of variables to null?

i believe there is but i cannot remember it
thanks
 
ChrisParks,

Take a look at Terminate Event; it sounds as if this is what you're looking for.
 


Hi,

Take a look at making a procedure that you can call to assign all your varaibles to an initial value.

Please note that NULL has a special meaning in VB that may not be what you intend...
VBA_Help said:
The Null value indicates that the Variant contains no valid data. Null is not the same as Empty, which indicates that a variable has not yet been initialized. It is also not the same as a zero-length string (""), which is sometimes referred to as a null string.


Skip,

[glasses] [red][/red]
[tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top