Populating combobox with named range, but only one item in range

[alfordtp]

I'm using the following for populating a combobox list

me.mn2.list = range("MFG2").value

This usually works, but sometimes there are cases where that named range only has one value in it. VBA is giving me an error with this.

"Run-time error 381: could not set the list property. invalid array index."

Is there a reason for this? Do I have to check every time whether there is more than one item? Hope not, that seems to be excessive.

thoughts?

Thanks in advance!

Tim

 

[My Aswer Is This]

I do not believe that is a proper named range.

When excel see's

MFG2
It thinks of this as a cell not a named range​

 

[alfordtp]

MFG2 is a named range in my workbook. I've used this protocol for populating combo boxes before and it works perfectly. This works when there are more than one entry in the named range.

 

[Fluff]

Are you using this in an old xls file?

 

[alfordtp]

After some more extensive searching, I found that you can count the items in the range, and if it equals 1, then add the item individually. If it is greater than 1, then I can use the method that I describe above.

thanks for your help anyway.

 

[Fluff]

Glad you sorted it & thanks for the feedback