Having problems populating a multicolumn listbox changing Listbox column with a loop.

Hi, Im trying to make a program that takes a value inside a cell and starts a loop from 1 to that value. Inside the loop, the listbox should get populated with different values inside a sheet and with a number of lines that's equal to the value taken before. Many im not explaining myself, I've got to succesfully populate my listbox with multicolumns for just one line, but when I try to achieve more than one line, the listbox replace the data already added with the new one that is intended to be in another line. This is the code im using right now:

--------------------------------------------------------------------------------------------------------------------------

Please Login or Register  to view this content.

--------------------------------------------------------------------------------------------------------------------------
When I execute it, the listbox that is intended to be filled with "f" number of lines, has only one, filled with the last data taken by the program. I believe the problem is inside the ".Column(0, b - 1)", where I thought the line would change depending on the value "b" has inside the loop. Sadly it didn't work. Any help would be greatly appreciated!

Hello Aristizabal95,

You need to move the Clear method out of the loop. Execute this before you enter the loop.

Please Login or Register  to view this content.