Add additional columns to user form combo box

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.

Norie,

I tried your suggestion and it still shows the second column after making the selection.

In reference to the 74 columns wide range, I'm selecting the entire database range, then on the part number column via the combo box, i'm selecting the record of interest to load into my user form. You probably are thinking it's comsuming a lot of computer resources to do this.

If i were to only populate the combo box with columns 2 and 6 from the database, then select the appropriate part number via the combo box, then go grab the remainder of the information from the corresponding row would likely take much less computer resources. Any thoughts on how to do this.

Thanks

Norie,

I tried the bound column to 2 in the combo box properties.

For the second question, i really don't notice much of a delay/lag in loading the user form.

Thanks