Error! Could not get the column property, Invalid argumnet

[z-eighty2]

Hello EveryOne!

I have got a UserForm which pulls data from Excel sheet and show it on UserForm.

UserForm1 has One ListBox name "ListBox1" and Thirteen TextBox's.

TextBoxBatch...... Showing Batch number
TextBox1 ........... Showing Year 1 data
TextBox2.............Showing Year 2 data
TextBox3...............Showing Year 3 data
.
.
.
.
TextBox12...........Showing Year 12 data



It shows data correctly in UserForm1 for TextBoxBatch and TextBox1 to TextBox9 but when it reaches TextBox10 it give error "Could not get Column property, Invalid argument"

and it does not show data in TextBox10 (Year 10), TextBox11 (Year 11), and TextBox12 (Year 12).

Here is code and I have alos attached workbook with userform.

Please Login or Register  to view this content.

Plz Help..I would be very thankful.

Kind Regards
z-eighty2

[Tsjallie]

Listbox seems to be limited to 10 culumns.
In this thread an alternative with Listview is discussed: http://www.excelforum.com/excel-prog...than-10-a.html.

[Norie]

Why are you populating a one column listbox with multiple columns?

[Izandol]

Listbox is only limited to 10 columns if you will use AddItem to populate it. If you create an array and assign this array to the List property, you may have many more columns.

[Norie]

Izandol

The OP's code sets the column count to 1, so why populate it with multiple columns the user can't see?

It would be easy enough to pull the data from the worksheet to populate the textboxes.

[Izandol]

I think it is easier to store the data in the listbox to populate the textboxes for the selected record.

[z-eighty2]

Hi Izandol,

Thanks for your reply.I am new to VBA, can you please edit my code which I have posted before so that I would be able to solve this problem.

I would be very thankful to you.

Kind Regards
z-eighty2

[Izandol]

For example:

Please Login or Register  to view this content.