I have a ComboBox as shown in the image below.
There is Listbox below it.
I want to get the Part Number which is the first part of the ComboBox item and then the Description, which is the second
part of the item and add a new row to the ListBox where the Part Number goes into the first column and the Description goes into the second part of the List Box. What VBA code would I use?