Hi,
I have a worksheet(code name: "ServLogSheet") having transactions table named "ServLogTbl". The table has 20 columns.
I need to fill up a listbox (lbCustLog) to display only some of the columns from the table.
I used the below code to do it. This worked till the number of columns to be displayed was up to 10.
Now, I need to display more than 10 columns from the ServLogTbl. Based on my search I found that the limit of listbox property columncount = 10 can be overcome if I use an array to fill the listbox using .listPlease Login or Register to view this content.
I can hide the not to be displayed columns of the ServLogTbl in the code. How do I select the visible table to fill an array? I tested the below code but only the first column of the table was filled in the array.
Please Login or Register to view this content.
Bookmarks