Call a constant/variable by creating another variable

[pienaaj]

Hi. I am trying to run through a series of constants based on filed names.
For example, I have x number of Constant field names named Field1, Field2, Field3, .......,Fieldx.
I would like to do something with the value of those field names without having to state the actual field name, but rather cycling through the fields

For Example:

Dim Record as integer

For Record=1 to x' which is the number of fields

OtherVariable=Field & Record 'I would like to use this to call the value of the constants

Next Record
'----------------------------------------------

This does not work. I am sure I need to do something to tell vba that "Field & Record" is actually a constant/variable and on text/.string.

Can anyone help?

[AndyLitch]

It sounds like you need an array variable which stores multiple variables and loop through them easily.

Please Login or Register  to view this content.

[Norie]

Where are these fields located?

[pienaaj]

The fields are constants before the sub routines.
I am not sure I explained this well before. I will give another example:
Say I define a constant:
Public Constant Field1=2

What I now want to do is call this constant value in a sub routine, but I do not want to explicity call field1.
I would like to call this constant value by calling "Field" & "1".
I imagine there is a function that will convert this tect value of "Field1" to recognise that this is the constant being referred to.

[MrShorty]

I'm going to agree with AndyLitch and suggest that what you want is an array. I don't know all the nuances of dealing with array constants defined outside of procedures, so there may be other ways to look at this. A structure like this might work

Please Login or Register  to view this content.

[Norie]

What to do these constants refer to?

Is it columns?

You can't refer to variables/constants by concatentating to get there name so using an array as Andy suggested might be the best idea.