Correct me if i am wrong but that doesn't account for if the data from the listbox is in the same order... i.e. listbox item 2 in column 2 >> data may actually be in column 3..
Could be having a brain fart here but..
In fact, when I did the solution suggested, it doesn't give me the right columns, when index the listbox
This is my list box :
If i select order 1, and it's number 2 in the list box i obtain column number 2, which isn't for order 1 datas
If i select Order 24 , number 15 in the listbox, it gives me column number 15, however concretely Order 24 exists in column 4 .....
This is what i just did; I convert the listbox to a string array and index it, within a for loop, and I index the 2D array , use " search in 1D array" the elemnts of the listbox but It doesn't work, i get a 1D of (-1), it means it doesn't find the elements, so i used a case structure to have only >0 indexs but it doesn't work either even though I have done many trials
Sorry for misunderstanding then 😉
Might not be the best way to do it, but a quick idea here :
Thank you so much That works well to extract the columns related to the selected orders,
Still how to obtain the indexs of these columns in reference to the initial array.
Output theloop counter (integer) the same way as I did for the text array.
you can use multicolumn listbox or table and get the index as well as data using point to row method, instead of searching.
Thank you so much for your help,
I made some other changes and finally it respond perfectly to what i want to do