Multi column ComboBox - How to Display the results of second column?

[nreyes2000]

Hello,

I need to display the results of a two-column combo box in different cells.

I know how to display the results for the first column:

Private Sub CommandButton1_Click()
Range("c72").Value = ComboBox1.Value
Unload Me
End Sub

But I cant figure out how to display the matching result from the second column in cell C73.

Thanks,
NR

[mikerickson]

You need to set the .TextColumn property of the combo box to the text that you want to appear in the combo box when it's selected. That is the .Text property of the combo box.
The .BoundColumn determines the .Value property.

Alternatly, you could directly access the (0-based) .List of the combo box, as in CommandButton2 below

Please Login or Register  to view this content.

[nreyes2000]

Perfect, thanks!