Prev: Automatically OPENing (GetObject) and Closing EXCEL via VB cal
Next: How do I stop my conttrols from resizing
From: norie on 28 May 2010 16:41
You can't construct varibale names like this in VBA.

Using a dictionary might be a workaround, so might an array approach.
From: ZipCurs on 29 May 2010 18:36
Hello Tim Williams,

Your recommendation works great. The only addition is to use

d.item("SnowShoe")= NewValue

to make "SnowShoe" behave like a variable and be able to call it by
assembling the name. Thanks.

"Tim Williams" wrote:

> Where/how is the variable "SnowShoe" defined ?
>
> If you really want to map data this way then you might use (eg) a
> dictionary object
>
> '**********************
> dim d as object
> set d=createobject("scripting.dictionary")
> d.add "SnowShoe", 20
> d.add "RainShoe", 10
> Msgbox d.Item("Snow" & "Shoe") '20
> '**********************
>
>
>
> Tim
>
>
> On May 28, 8:32 am, ZipCurs <ZipC...(a)discussions.microsoft.com> wrote:
> > Hello,
> >
> > This is probably easy ... or impossible, but I cannot figure out how to do
> > this. I want to assembly a variable name in code, and then get that
> > variable. Separate parts of my macro tell me my prefix is "Snow" and my
> > suffix is "Shoe". How to I get the value of "SnowShoe"? I have a lot of
> > these variables. The following does not work:
> >
> > VariableIWant="Snow" & "Shoe"
> > NumberINeed=5+VariableIWant
> >
> > I ended up with a bunch of If statements. Effective but not too elegant.
> > Any help would be appreciated. Thank you in advance.
>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Automatically OPENing (GetObject) and Closing EXCEL via VB cal
Next: How do I stop my conttrols from resizing