Userform Combobox

[benntw]

I haven't built a userform in a long time. I have an old file that I have multiple comboboxes on and all of them I used the RowSource to populate them. I have a named range on a sheet to populate the combobox and it will not allow me to type the name into the RowSource. Has something changed in excel recently to cause this ?

 

[DanteAmor]

I haven't built a userform in a long time. I have an old file that I have multiple comboboxes on and all of them I used the RowSource to populate them. I have a named range on a sheet to populate the combobox and it will not allow me to type the name into the RowSource. Has something changed in excel recently to cause this ?

How old is your file?
At least since 2003 there has been no change to adding a named range in the RowSource property of a combobox.

But you must put a correct name to the named range.

You can put your example of combo and named range here to review

 

[benntw]

I am using the newest excel. My named range is called Crafts. When I type in Crafts into the RowSource for combobox1 the error pops up " Could not set the RowSource property. Invalid property value." I have never had this error come up when I would type in the named range

 

[DanteAmor]

When I type in Crafts into the RowSource for combobox1 the error pops up " Could not set the RowSource property. Invalid property value."

Are you doing it directly in the combo property or during the userform execution in the activate event or the initialize event?

I insist, you already checked that you have the named range: "Crafts"

 

[benntw]

I am typing the named range in RowSource under Combobox1 properties. For right now I had to put my list under add items under Userform_Initialize for now since I cannot use the RowSource

 

[DanteAmor]

You could show images, for example: Here is the name manager, I can see the range named: Crafts

In the rowsource property of the listbox I can put "Craft"

If you don't give your examples, we are simply blind

 

[benntw]

Now I see what it didn't like. It did not like that I had this formula for the named range . =OFFSET(LookUps!$B$1,1,0,COUNTA(LookUps!$B:$B)-1,1). I selected the range and now it works. Thank you