I currently load a dropdown combo box on a form and use additem method to populate it with data formatted from 6 columns and 100 rows on page 2 of the workbook. It would like to turn this control into a dropdown combo box or dropdown list box, with extended multi-select options.
Problems:
Active X list box and combo box controls
!) The dropdown combo box has no multi-select property.
2) The list box has no listrows property-data displays only one row at a time.

Using the forms control box to add a drop down list box to a cell on the form
3) I cannot format the data properly for a drop down list box-cant display data using the additem method to format the data.


Any idea how to create a multi-select combo box or a drop down list box that will show 10 rows of data in the drop down portion of the list box?