Creating Combo Box List from a named range that is in a row

[baidya91]

Some data are in a row. They are renamed. Can the renamed range be converted into a combo box list?
For example, names of days namely Sunday, Monday.........Saturday are in a row in place of a column. The range is renamed as 'day'. Can the renamed range be converted into a combo box list? If yes, how?

 

[Zot]

Are we talking about ActiveX ComboBox and you want to put formula in ListFillRange?

 

[baidya91]

Are we talking about ActiveX ComboBox and you want to put formula in ListFillRange?

Yes, Sir

 

[Zot]

Yes, Sir

Sorry, I have no idea on how to Transpose directly in the formula. Did not work in Property there

 

[My Aswer Is This]

Try this:

Private Sub CommandButton1_Click()
'Modified  5/31/2021  4:50:46 AM  EDT
Dim r As Range
ComboBox1.Clear

For Each r In Range("day")
    ComboBox1.AddItem r.Value
Next
End Sub

 

[Zot]

Try this:

Private Sub CommandButton1_Click()
'Modified  5/31/2021  4:50:46 AM  EDT
Dim r As Range
ComboBox1.Clear

For Each r In Range("day")
    ComboBox1.AddItem r.Value
Next
End Sub

I think he is looking for non-VBA solution. Perhaps can only use helper column?

 

[My Aswer Is This]

I think he is looking for non-VBA solution. Perhaps can only use helper column?

I see nothing about not using Vba. And what can you do with a Combobox without using vba.

 

[Zot]

I see nothing about not using Vba. And what can you do with a Combobox without using vba.

I did ask about putting formula in ListFillRange in ComboBox property. Since he said yes, I presumed.