Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Declaring Variables
I'm either horribly confused, or old age is taking its toll. But there seems
to be too many options for declaring variables and I;m having trouble figuring out the best way for declaring variables. Tell me if I have it straight: variables declared at the top of a module are shared within all procedures in the module, decalred within a procedure/function are available to only that procedure/function variables declared Public are available to all modules - in this workbook only or all workbooks? - so these should be declared at the top of a module? variables declared Static retain their values between procedure/function calls - declare in a procedure/function variables do not retain their values once hte code stops and control returns to the user, so if you want to retain values you need to stor ethem in a cell in the spreadsheet Sound right? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Declaring Variables
Does these articles help.
http://www.ozgrid.com/VBA/variable-scope-lifetime.htm http://www.java2s.com/Code/VBA-Excel...sics/Const.htm "BlairH" wrote: I'm either horribly confused, or old age is taking its toll. But there seems to be too many options for declaring variables and I;m having trouble figuring out the best way for declaring variables. Tell me if I have it straight: variables declared at the top of a module are shared within all procedures in the module, decalred within a procedure/function are available to only that procedure/function variables declared Public are available to all modules - in this workbook only or all workbooks? - so these should be declared at the top of a module? variables declared Static retain their values between procedure/function calls - declare in a procedure/function variables do not retain their values once hte code stops and control returns to the user, so if you want to retain values you need to stor ethem in a cell in the spreadsheet Sound right? Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Declaring Variables
I notice the specific question marks only now..Answers within brackets
- in this workbook only or all workbooks? (In this workbook) - so these should be declared at the top of a module? (Yes) variables declared Static retain their values between procedure/function calls - declare in a procedure/function (Yes) -variables do not retain their values once hte code stops and control returns to the user, so if you want to retain values you need to stor ethem in a cell in the spreadsheet Sound right? (Variables declared on top will retain their values all through that Application session OR until Excel application is closed (assuming they are not initialised within code)) "Jackpot" wrote: Does these articles help. http://www.ozgrid.com/VBA/variable-scope-lifetime.htm http://www.java2s.com/Code/VBA-Excel...sics/Const.htm "BlairH" wrote: I'm either horribly confused, or old age is taking its toll. But there seems to be too many options for declaring variables and I;m having trouble figuring out the best way for declaring variables. Tell me if I have it straight: variables declared at the top of a module are shared within all procedures in the module, decalred within a procedure/function are available to only that procedure/function variables declared Public are available to all modules - in this workbook only or all workbooks? - so these should be declared at the top of a module? variables declared Static retain their values between procedure/function calls - declare in a procedure/function variables do not retain their values once hte code stops and control returns to the user, so if you want to retain values you need to stor ethem in a cell in the spreadsheet Sound right? Thanks! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Declaring Variables
Those article sdo help. Thanks.
"Jackpot" wrote: Does these articles help. http://www.ozgrid.com/VBA/variable-scope-lifetime.htm http://www.java2s.com/Code/VBA-Excel...sics/Const.htm "BlairH" wrote: I'm either horribly confused, or old age is taking its toll. But there seems to be too many options for declaring variables and I;m having trouble figuring out the best way for declaring variables. Tell me if I have it straight: variables declared at the top of a module are shared within all procedures in the module, decalred within a procedure/function are available to only that procedure/function variables declared Public are available to all modules - in this workbook only or all workbooks? - so these should be declared at the top of a module? variables declared Static retain their values between procedure/function calls - declare in a procedure/function variables do not retain their values once hte code stops and control returns to the user, so if you want to retain values you need to stor ethem in a cell in the spreadsheet Sound right? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Declaring Variables Twice? | Excel Programming | |||
Declaring variables | Excel Discussion (Misc queries) | |||
Declaring variables | Excel Discussion (Misc queries) | |||
Declaring Variables | Excel Programming | |||
Declaring Variables | Excel Programming |