populating userform combo box from dynamic named range

[wpryan]

Hi All,

I have a userform which gets its data from a dynamic named range. The combo box is properly populated if there is more than one item in the list, but throws up a "run-time error 381: Could not set List property. Invalid property array index" if there is only one item in the list. I'm hoping there is a simple solution to this. The code I'm using for this is (in case it can be helpful):

Please Login or Register  to view this content.

Further investigation indicated to me that the problem is that the userform is starting from a named range which "grows", starting from an index of zero. This is the source of the problem. What is the workaround?

This is cross-posted at http://www.mrexcel.com/forum/excel-q...med-range.html.

[Norie]

Perhaps.

Please Login or Register  to view this content.

[wpryan]

That did the trick! Thanks much!