Good afternoon,

I'm trying to load some values in a combobox using a combination of a named range and another combobox :

```
CBOX_NOMENCLAT.value = "SOCIAL"

```

When the value of this first combobox changes, it loads the second where I have my problem :

```
Private Sub CBOX_NOMENCLAT_Change()
    With CBOX_MOTIF
        .RowSource = Range(CBOX_NOMENCLAT)
    End With
End Sub

```

I indeed have a named range called `"SOCIAL"` returning 3 values. I would like them to be loaded in my `CBOX_MOTIF` (see below "MOTIF OD").

[![My 2 combo boxes](https://i.stack.imgur.com/IXZes.png)](https://i.stack.imgur.com/IXZes.png)

I thought about using the `INDIRECT` function but I couldn't find a way to make it work.

Could you please help me? Thanks!