refer variable name by value from string

[zico8]

Hi,

I have some defined variables where have added some values:

temp_1 = "red"
temp_2 = "black"
temp_3 = "blue"
etc.

how can I refer to the correct one by text string?

msgbox = "temp_" & selection.row

 

[gallen]

To refer to named ranges you just need to use the range object:

[COLOR=#333333]msgbox = Range("temp_") & selection.row[/COLOR]

 

[zico8]

Thanks gallen but it does not work,

It would be if I had defined these names inside worksheet but I have these as variables.

 

[Fluff]

How about

Sub demo()
   Dim temp(1 To 3) As String
   Dim i As Long
   
   For i = 1 To 3
      temp(i) = Choose(i, "Red", "Black", "Blue")
   Next i
   
   MsgBox temp(Selection.Row)
End Sub

 

[zico8]

Yes,

It works for sample I have given here.

But my issue is a little different in fact. I am stricte interested how can I add any of string to variable name I am looking for.

 

[Fluff]

AFAIK there is no way of getting a variables contents by concatenating strings.

 

[zico8]

Are you sure?

In a worksheet I would probably do it with INDIRECT function.

 

[RoryA]

You could store the variables in a collection or dictionary, or use a class to hold the variables. There are generally better ways of approaching it though - whenever I've seen people ask this question in the past, they have been overcomplicating things.

 

[zico8]

Hi RoryA,

I am looking for that way because I have several variables storing values and need to get these into table where its headers are named the same as part of variable's names.

For example my tyble headers are named "1", "2", "3" and this is why I try to get the correct variable value into correct table column.
defined variables:

[COLOR=#333333]temp_1 = "red"[/COLOR]
[COLOR=#333333]temp_2 = "black"[/COLOR]
[COLOR=#333333]temp_3 = "blue"[/COLOR]

[COLOR=#26282A][FONT=&quot]for my_table_column = 1 to my_table.listcolumns.count
[/FONT][/COLOR]my_table.range.cells(i, my_table_column) = "temp_" & my_table.headerrowrange(my_table_column).value
next my_table_column

 

[RoryA]

That looks ideal for an array as Fluff showed you.