Loop through custom variables

**Khaos176** · 10-14-2009, 01:13 PM

Hello all I have a question and it is hard to explain. I have multiple variables that start with "HrIn" and then a number ex HrIn1, HrIn2.....etc.
What i am trying to do is use them in a similar way to the
Me.Controls("Control" & Variable) = XX where i can use the Variable to determine which control I am referring to and that control would = whatever "XX" is.
SO I thought it would look something like:
HrIn(Var) = XX where "Var" is a variable that is set to a specific number.
This does not work and I am running out of ideas.
I am including the code i am working to maybe help with my explanation.
Thanks

Please Login or Register  to view this content.

**shg** · 10-14-2009, 01:17 PM

You could use a dictionary, where the Key is the variable name and the Item is the value. See VBE Help for Dictionary Object.

BTW, in your declaration, everything except oddFrame is declared as a Variant.

**Khaos176** · 10-14-2009, 01:31 PM

Thank you for the quick reply!!!
I am trying to figure out the Dictionary Object but i dont quite understand it. Ill keep trying.
On the variants, I did not include everything.
Thanks again

**shg** · 10-14-2009, 01:32 PM

Please Login or Register  to view this content.

a and b are variants

Please Login or Register  to view this content.

all are longs.

**Khaos176** · 10-14-2009, 01:45 PM

I see what you mean now. I did not know that. I thought the way I have them was correct. Thank you

Loop through custom variables

LinkBack

Thread Tools

Rate This Thread

Display

Loop through custom variables

Re: Loop through custom variables

Re: Loop through custom variables

Re: Loop through custom variables

Re: Loop through custom variables

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions