List box - RunTime Error '380':Could not set the list property.invalid property value

Hi all,

I am working on a spreadsheet with 14 columns. When i search for a value in the first column and try to populate a list box with the matching value and row. I am getting the following error

Run-Time Error '380': Could not set the list property. invalid property value.

The code i am using for populating the list box is shown.
I was able to utilize the code for a 10 column spreadsheet. I updated it for use on the 14 column spreadsheet but i am stuck. The code stops on the line with
.List(.ListCount - 1, 10) = c.Offset(0, 10).Value.

Any ideas what i am doing wrong?

Thank you for all your help

Please Login or Register  to view this content.

Hello hey1000,

Both the ListBox and CombBox controls have a 10 column limit unless they are bound to a worksheet range. You specify the range in the control's RowSource property. The other problem is the cells must all be contiguous (touching each other). The visible cells of a filter operation are rarely contiguous. There are usually lots of breaks between rows. You have to use 2 loops to get the values of all the cells. The first loop steps through each "Area" or group of contiguous cells. The second loop steps through each of the "Areas".