Error...When pulling data from worksheet to UserForm

**z-eighty2** · 02-11-2014, 05:30 PM

Error! Could not get the column property, Invalid argumnet

Hello EveryOne!

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

UserForm1 has TextBox's as follow:

ComboBox1.......Select Year
ComboBox2.......Select Batch
TextBoxYear........Showing Year
TextBoxBatch...... Showing Batch number
TextBox1 ........... Showing Month 1 data
TextBox2.............Showing Month 2 data
TextBox3...............Showing Month 3 data
.
.
.
.
TextBox12...........Showing Month 12 data

It shows data correctly in UserForm1 for TextBoxYear, TextBoxBatch and TextBox1 to TextBox7 but when it reaches TextBox8 (Month 8) it give error "Could not get Column property, Invalid argument"

and it does not show data in TextBox8 (Month 8) .......to..........TextBox12 (Month 12) and give error in code from
".TextBox8 = ListBox1.Column(10)"

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

Please Login or Register  to view this content.

Please Help
Kind Regards

z-eighty2

**buran** · 02-11-2014, 05:49 PM

Isn't this the same problem for which there is a thread started few days ago and which is answered by Norie?

www.excelforum.com/excel-programming-vba-macros/986780-could-not-get-the-column-property-invalid-argumnet-error-plz-help.html

**z-eighty2** · 02-11-2014, 06:20 PM

Hi Buran!

It is almost the same problem but a little bit differnce.

In the thread posted few days ago, In that Userform the Data was searched by using a single ComboBox "Select Batch".

But in today's thread, In the Userform1 the data is searched by using 2 ComboBox's. "Select Year" and "Select Batch" which pulls data from worksheet to ListBox1 (UserForm1)

but when it is clicked in the listbox1 to show data in Textbox's it gives error.

If you see my attached workbook above it would explain better.

Plz help

Kind Regards
z-eighty2

**buran** · 02-12-2014, 03:02 AM

z-eighty2 ,
A minor tweak of the UI doesn't make it a different problem, as long as it is irrelevant to the listbox (where your problem is) and the limitations you have when using AddItem method.
From the other thread:

Originally Posted by Norie

You can't populate a listbox with more than 10 columns using the AddItem method.

Since you are only displaying one column in the listbox why not just populate that one column.

Then take the data for the textboxes from the worksheet instead of the listbox.

So you are still trying to put more than 10 columns of data in the listbox.

**Fotis1991** · 02-12-2014, 03:07 AM

Originally Posted by buran

z-eighty2 ,
A minor tweak of the UI doesn't make it a different problem, as long as it is irrelevant to the listbox (where your problem is) and the limitations you have when using AddItem method.
From the other thread:

Thanks buran!

So.

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.