Displaying combobox value in textbox when combobox list is array

[Prevost]

Hi There. I have a combobox which I populated with a two dimensional array.

Sub Test()
    With ComboBox1
        .List = DisplayArray
    End With
    Textbox1 = ComboBox1.Value
End Sub

The textbox value now just contains the value in the first column of the array (the array only has 2 columns). Am I able to have the textbox display both values as displayed in the combobox?

Thanks!

 

[dmt32]

Hi,
try using the Column Property:

Private Sub ComboBox1_Change()
    With Me.ComboBox1
        Me.TextBox1 = .Column(0) & " " & .Column(1)
    End With
End Sub

Column is a zero-based property, the first column is 0, the second 1 and so on.


Dave

 

[Prevost]

Thank you! That is what I needed. Is the same methodology used to display both array values in the combobox as well? Because right now only the first array value displays in the combobox once a value is selected.