Hi,
I have a problem using VBA-code to fill up a multicolumn listbox with in the first column the customer number and in the second column the corresponding customer's name. I use MicroSoft Excel 97.
To do this I have a spreadsheet with, let's say, 2 columns where the A-column contains th customer number and the B-column contains the corresponding customer name. BUT the data is not sorted and not unique. So there are duplicate combinations of customer number and names.
I want to have a listbox representing in ascending order the customer number and its corresponding name on one line-item.
In the book "Excel 2002 Power Programming with VBA" by J. Walkenbach I found an example working with 1 column, but I can not figure out to make this working with 2 columns.
Can someone provide me a VBA-macro code solving this ?
Thanks in advance for any help.
I have a problem using VBA-code to fill up a multicolumn listbox with in the first column the customer number and in the second column the corresponding customer's name. I use MicroSoft Excel 97.
To do this I have a spreadsheet with, let's say, 2 columns where the A-column contains th customer number and the B-column contains the corresponding customer name. BUT the data is not sorted and not unique. So there are duplicate combinations of customer number and names.
I want to have a listbox representing in ascending order the customer number and its corresponding name on one line-item.
In the book "Excel 2002 Power Programming with VBA" by J. Walkenbach I found an example working with 1 column, but I can not figure out to make this working with 2 columns.
Can someone provide me a VBA-macro code solving this ?
Thanks in advance for any help.