Populate Userform Comobox List With A Named Range

[Ark68]

I have this code:

    ActiveWorkbook.Names.Add Name:="nr_funct", RefersTo:=nr_func
    permit.cbx_func.Enabled = True
    permit.cbx_func.List = range("nr_funct")

I'm not finding any luck in figuring out how to apply the contents of named range "nr_funct" as the selection list for my userform's combobox 'cbx_func'.

Its likely a very basic error I'm overlooking, but I'm stumped. All help is appreciated!

 

[Legacy 456155]

cbx_func.RowSource = "nr_funct".
If your named range contains multiple columns, you will need to set a few properties of you combo box such as ColumnCount and perhaps ColumnWidths.

This works as well.
cbx_func.List = Application.Transpose(Application.Transpose(Range("nr_funct")))

 

[Fluff]

You need to use .Value when assigning the range to a list

permit.cbx_func.List = range("nr_funct").Value

 

[Legacy 456155]

You need to use .Value when assigning the range to a list

I did not know that. Isn't Value the default property of a range? I wonder why you have to add it. Nevertheless, it works. Thanks!

 

[Ark68]

Thank you both for coming to my help.
Dataluver, just a simple range of one columns worth of data. I think I have all the properties set up as needed.
Thank you Fluff. I was hoping it would be that easy. That's likely why my Google searches ended up empty.

 

[Fluff]

You're welcome & thanks for the feedback.