How to Concatenate a variable name in a vba loop ?

Const Value1 as long = 5
Const Value2 as long = 12
Const Value3 as long = 7

For i = 1 to 3
MsgBox Value & i '<-- How to do this properly?
Next i

I want MsgBox to display 5 then 12 then 7
I can't figgure out how to get Value and i to combine properly to do this.

thanks for any help.

PS - This is a repost as I didn't ask the question correctly last time.

But you are happy with the last answer you got?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"tmb" <[email protected]> wrote in message
news:u%[email protected]...
> Const Value1 as long = 5
> Const Value2 as long = 12
> Const Value3 as long = 7
>
> For i = 1 to 3
> MsgBox Value & i '<-- How to do this properly?
> Next i
>
> I want MsgBox to display 5 then 12 then 7
> I can't figgure out how to get Value and i to combine properly to do this.
>
> thanks for any help.
>
> PS - This is a repost as I didn't ask the question correctly last time.
>
>

I am happy Bob.

thanks for the help.

"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> But you are happy with the last answer you got?
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "tmb" <[email protected]> wrote in message
> news:u%[email protected]...
>> Const Value1 as long = 5
>> Const Value2 as long = 12
>> Const Value3 as long = 7
>>
>> For i = 1 to 3
>> MsgBox Value & i '<-- How to do this properly?
>> Next i
>>
>> I want MsgBox to display 5 then 12 then 7
>> I can't figgure out how to get Value and i to combine properly to do
>> this.
>>
>> thanks for any help.
>>
>> PS - This is a repost as I didn't ask the question correctly last time.
>>
>>
>
>

That's okay, just checking as the times seemed to suggest this came after
the last posting.

Regards

Bob


"tmb" <[email protected]> wrote in message
news:[email protected]...
> I am happy Bob.
>
> thanks for the help.
>
> "Bob Phillips" <[email protected]> wrote in message
> news:[email protected]...
> > But you are happy with the last answer you got?
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "tmb" <[email protected]> wrote in message
> > news:u%[email protected]...
> >> Const Value1 as long = 5
> >> Const Value2 as long = 12
> >> Const Value3 as long = 7
> >>
> >> For i = 1 to 3
> >> MsgBox Value & i '<-- How to do this properly?
> >> Next i
> >>
> >> I want MsgBox to display 5 then 12 then 7
> >> I can't figgure out how to get Value and i to combine properly to do
> >> this.
> >>
> >> thanks for any help.
> >>
> >> PS - This is a repost as I didn't ask the question correctly last time.
> >>
> >>
> >
> >
>
>