I have the following code that populates a combo box with data from the 6th column within the workbook Log File.

I'm attampting to add one if not more additional columns to this combo box, specifiaclly i wanted to show column 2 . I changing the column count in the combo box propeties and changed the column width string below to account for the additional columns and it displays fine, a product type and part number, however when i select the part number i want from column 6, the combo box shows the corresponding value from column 2. The data does load correctly to the user form, it just looks strange when the combo box shows the column 2 value, does anyone have an idea how i can show the value from column 6 when selection is made?

Thanks


Please Login or Register  to view this content.