Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Location
    Bay Area
    Posts
    511

    Unanswered: How to set up a Multi-Column Combo

    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
    Attached Files Attached Files

  2. #2
    Join Date
    Jan 2002
    Location
    Bay Area
    Posts
    511
    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
    Attached Files Attached Files
    Last edited by JerryDal; 10-05-11 at 16:48.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •