Transfer Textbox/Combobox Values to a Multiple Column Listbox Error381

[el-paso]

Hi

I have a userform with lots of textboxes/combobox's. What Im trying to do is transfer these values into a multiple column listbox using the following code but I keep getting error 381.
Could someone help where I am going wrong.
Furthermore, I havn't got this far yet but thinking ahead, I want a separate command button that once the list box is populated, it will transfer the data in each column into the next blank row on the spreadsheet. Is this possible?

This is the code to the first problem:

Please Login or Register  to view this content.

Thanks in advance

[mehmetcik]

You are getting this wrong in all sorts of ways.

I will explain why but first lets sort your problem.

This line is causing your error

Please Login or Register  to view this content.

Your code is trying to add data to a Listbox line that does not exist

Replace that line with:

Please Login or Register  to view this content.

This will create line 0 so the rest of the code should work.


Now my main bug bear is that you are making your coding so complicated that you will have issues going forward.

I name all my controls by the column number on the database that they are stored in.

Then you can use code like this to read and write to and from an infinite number of controls:

Please Login or Register  to view this content.

Or:

Please Login or Register  to view this content.