Add additional columns to user form combo box

[jprlimey]

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

Private Sub Userform_Initialize()
    Dim Sourcewb As Workbook
    Dim myRng As Range
    
    With Me.cbxPlanning
        .ColumnCount = 6
        .ColumnWidths = "0;50;0;0;0;12"  'hide the second column
        .Clear
        Set Sourcewb = Workbooks.Open("Log File.xlsm", False, True)
        With Sourcewb.Worksheets(1)
            Set myRng = .Range("A2:BV" & .Cells(.Rows.Count, "A").End(xlUp).Row)    
        End With
        .List = myRng.Value
        Sourcewb.Close False
    End With
End Sub

[Norie]

Change the bound column of the combobox to show a specific column.

By the way, why is the range you are populating the combobox with 74 columns wide?

[jprlimey]

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]

What exactly did you try?

As for loading all the data into the combobox, that's not an approach I use a lot so I'm not sure if there is any impact on resources.

Have you noticed anything? For example a bit of a lag when you open the form.

[jprlimey]

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

[Norie]

I thought you wanted column 6 displayed not column 2?

You should set the bound column to the column you want displayed.

[Norie]

Actually it's TextColumn you need to use to set which column is displayed.