var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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.
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.
EnableEvents is disabled in the form Activate event while the combo box is being populated, then enabled when finished.
Private Sub ComboBox1_Change()
If Not Application.EnableEvents Then Exit Sub
Me.Label1.Caption = Me.ComboBox1.Column(1)
Last edited by JerryDal; 10-05-11 at