Hi all,
I would like to set up a listbox, populated with names from a range on a worksheet (i.e. A1:A10). When a user selects items in that list, the routine needs to, for each selected item, return the corresponding value located in the same row but in the adjacent column (B1:B10). This would be akin to using common names in column A and the corresponding values in the adjacent column (B) would be the catalog #s. The catalog #(s) for the selected items then would be entered into a target range on a specified worksheet. How can I go about getting the listbox on a userform to provide me with the value(s) in the second column but showing/using the item names in the first column?.
Thanking you all in advance.
I would like to set up a listbox, populated with names from a range on a worksheet (i.e. A1:A10). When a user selects items in that list, the routine needs to, for each selected item, return the corresponding value located in the same row but in the adjacent column (B1:B10). This would be akin to using common names in column A and the corresponding values in the adjacent column (B) would be the catalog #s. The catalog #(s) for the selected items then would be entered into a target range on a specified worksheet. How can I go about getting the listbox on a userform to provide me with the value(s) in the second column but showing/using the item names in the first column?.
Thanking you all in advance.