ListBox Problem...

[collamack]

i'm designing a form using macro. but i stuck when i want to view data from excel in list box.

Name: ListBox1
ColumnCount: 100
ColumnBound: 100

The function:
when user click on cmbFindAll, all particular data for particular comName are listed in TextBox1. it's successful if only till 9th column. when i tried to put 10th column, the error will be occurred.

could not set list property. invalid property value

this is my coding

Please Login or Register  to view this content.

[royUK]

I don't think that a listbox can have 100 Columns.

[collamack]

so, what should i do? when i click 'Select', it only shows details from listbox1. not from db excel...

[Leith Ross]

Hello collamack,

In VBA you are limited to 10 columns (0 - 9) if your ListBox is unbound. To bind your ListBox to the worksheet use the RowSource property to define the range of interest. The maximum column limit for a bound control is 256.

Sincerely,
Leith Ross

[royUK]

100 Columns is not going to be very functional anyway! Leith's suggestion will not work in this case because the data you are trying to add is a filtered range. The only thing you could do to implement his suggestion is to copy the filtered range to another location then set the new range as the rowsource.