How to set up a Multi-Column Combo

JerryDal · #1 (**permalink**) 10-04-11, 23:44

How do you set up a a multi-column combo in an Excel 2003 form. When the drop-down is clicked the two columns of data are in view. When I pick one, only the fist column appears. See attachment. Thanks.
Jerry

JerryDal · #2 (**permalink**) 10-05-11, 15:44

It may be that an Excel combo box can only display one field when it is collapsed. Does anyone know where that is documented, or is it just common knowledge?

I put a label over the combo box and adjusted its TOP property to line up with the combo text. The solution can be seen in the attachment.

Code:

Private Sub ComboBox1_Change()

    If Not Application.EnableEvents Then Exit Sub
    Me.Label1.Caption = Me.ComboBox1.Column(1)
    Me.cmdClose.SetFocus

End Sub

EnableEvents is disabled in the form Activate event while the combo box is being populated, then enabled when finished.

Jerry
RESOLVED

Internet Services

Web Development

Digital Marketing

Consumer Tech