combo list change of items

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

Hello Mr Leith Ross
Yes, sure.

please find attached a sample that summarizes the case.

In sheet one there is the list of the items of combo.
I create a name by insert->create->name.
this variable is called "one", and is assigned to the proprieties of the combo by the window.
By clicking the command button, I assign to a variable, called variab, a true value.

Utilizing this variable I would like to change the items of the combo to three different ones.

My problem is that I don't know how to do it.
Please, could you help me ?

Many thankssample combo.xls