This is out of VBA help file for ListBox properties, column count.

Setting ColumnCount to 0 displays zero columns, and setting it to -1
displays all the available columns. For an unbound data source, there is a
10-column limit (0 to 9).



"Ed Sowell" wrote in message
...
I am trying to display a table with 22 columns and about 100 rows in a
ListBox in a User form. When it runs I get the message:

Error 380: Could not set the List property. Invalid property value.

This happens while loading the first row. If I just load about 10 columns
it will load all the rows.

Is there a limit on ListBox columns?

TIA

Ed