hello
hope you are fine.

Please, I hope somebody could help me.

I have a combo box where different items.

(ex
item(0) one,
item(1) two,
item(2) three

this items are currently got from a row source. I create a name (Insert>Name>Create from Excel) and from there I get the values setting the row source to the name created

I would like these texts to change according to a variable.(I'd like to call them in different languages).
Ex, if this variable is true, instead than one,two,three I would like the items to be, ex

item(0) red,
item(1) green,
item(2) blue.

How can I set it by code ?
Can I utilize some property of combo box or shall I use a different solution ?


many thanks