Storing variables in VBA
I am new to VBA and am coding in Excel 2007.
I have learned about events and writing sub-routines that I can execute fromthe events. I need to have a few global variables though.
How do I do that?
Thanks.
I have learned about events and writing sub-routines that I can execute fromthe events. I need to have a few global variables though.
How do I do that?
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
> Define the variables in a general code module in the top declaration section as:
In which sheet?
> Why do you need global variables?
I may need to limit the frequency with which I download data from the database. Maybe every 10 minutes, for a given table.
I am not sure but want to have the ability to do it if I need to...
In which sheet?
> Why do you need global variables?
I may need to limit the frequency with which I download data from the database. Maybe every 10 minutes, for a given table.
I am not sure but want to have the ability to do it if I need to...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks!
http://www.ozgrid.com/VBA/variable-scope-lifetime.htm
~bp