Re: Initializing variables

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Well, I didn't promise that my suggestion could always be used... I did say "probably" and offered the conditions under which it would work. If you still wanted to try the approach, and didn't mind using a Variant, then you could do it this way...

Function Foo() As Variant
Static MyVariable As Variant
If IsEmpty(MyVariable) Then MyVariable = 10000
....
....
End Function

This works because Variants start off defaulted to Empty and will never be Empty again unless specifically set to it. Of course, you could always use another variable as an initialization switch too, you know.<g>

--
Rick (MVP - Excel)


"Don" <don87109@xxxxxxxxxxx> wrote in message news:eboODOlXJHA.1328@xxxxxxxxxxxxxxxxxxxxxxx
Rick,

Thanks for the suggestion, but I don't think it works in my case. That's because the normal range of values potentially stored in MyVariable is zero.

However, maybe I could add a constant to any MyVariable values to avoid zero. I just have to remember to subtract that constant anytime I want the true value of MyVariable.

On second thought maybe it's easier just to have another variable as an initialization switch.

Don

"Rick Rothstein" <rick.newsNO.SPAM@xxxxxxxxxxxxxxxxxx> wrote in message news:ORsY35ZXJHA.5272@xxxxxxxxxxxxxxxxxxxxxxx
You probably don't need another variable to serve as an initialization switch... you can probably just use the contents of the variable itself. For example,

Function Foo() As Variant
Static MyVariable As Long
If MyVariable = 0 Then MyVariable = 10000
....
....
End Function

As long as MyVariable is never reset to 0, it will retain the last value assigned to it whenever the function is called (the Static rather than Dim statement sees to that).

--
Rick (MVP - Excel)


"Don" <don87109@xxxxxxxxxxx> wrote in message news:%23RRIMmWXJHA.2444@xxxxxxxxxxxxxxxxxxxxxxx
Chip and Dana,

Thanks for the feedback. I'm amazed that you can't set a value on the dim statement. Oh well, the variable does change so I'll have to add code to somehow initialize it the first time the function is executed.

I guess I'll have to use another variable to serve as an initialization switch. I'll set that variable to "one" after the main variable is initialized and then use that "one" in an If statement to skip the initialization code whenever the function is subsequently called.

Don

"Dana DeLouis" <ddelouis@xxxxxxxxxxxxx> wrote in message news:uhfaVaWXJHA.760@xxxxxxxxxxxxxxxxxxxxxxx
> can't find a way to do this on the Dim statement.

Just to mention...if the variable won't change, perhaps use a constant.
The idea being that you dim it and set its value at the same time.

Const Pi As Double = 3.14159

= = =
Dana DeLouis


Don wrote:
I'm writing a Function and need to initialize a variable to say 10,000. I can't find a way to do this on the Dim statement. Of course I can initialize it programmatically in the code section, but that seems overly complicated. Is there a simple way to initialize variables?

Bear in mind I only want to initialize once and not each time the Function is invoked.

Don






.

Relevant Pages

  • Re: Initializing variables
    ... Static tempHiWater As Variant ... Rick (MVP - Excel) ... always use another variable as an initialization switch too, ...
    (microsoft.public.excel)
  • Re: Initializing variables
    ... Rick ... If you still wanted to try the approach, and didn't mind using a Variant, then you could do it this way... ... On second thought maybe it's easier just to have another variable as an initialization switch. ... As long as MyVariable is never reset to 0, it will retain the last value assigned to it whenever the function is called (the Static rather than Dim statement sees to that). ...
    (microsoft.public.excel)
  • Re: Delphi.NET
    ... Since arrays need initialization, .NET will not allow this in a variant type record. ... the following code will not compile because the array type needs to be initialized. ... MyActType: TTestRec; ...
    (comp.lang.pascal.delphi.misc)
  • Re: Initializing variables
    ... Function FooAs Variant ... another variable as an initialization switch too, ... Dim statement sees to that). ...
    (microsoft.public.excel)
  • Re: Initializing variables
    ... Function FooAs Variant ... another variable as an initialization switch too, ... Dim statement sees to that). ...
    (microsoft.public.excel)