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:
--------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------
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!
Bookmarks