Charlize
09-27-2006, 04:06 AM
With userform1.listbox1.value you can get the value of the first column in a listbox.
How can I use the 2nd or third value of a row in a listbox.
Something like userform1.listbox1.item(2).value. This refers to column no2 of the row that was selected in the listbox.
Needed for duplicate items in the first column. I can't use a vlookup for the rest of the info because of this.
How can I use the 2nd or third value of a row in a listbox.
Something like userform1.listbox1.item(2).value. This refers to column no2 of the row that was selected in the listbox.
Needed for duplicate items in the first column. I can't use a vlookup for the rest of the info because of this.