ListBox to list multiple columns

[Michael515]

Hi Y'all,

I have created an ActiveX ListBox and have linked it to one of my defined ranges. The defined range refers to cells $A$1:$E$500. I wanted the list box to display each row itself as a choice in a multi select fashion, ex. you can choose rows 5, 67, 132, 402, etc. The problem is, that my list box only displays column A in the field to be chosen from, where as you need to see the other columns in order to make an informed selection. Is there any easy way to expand this to show all the columns and therefore have a bottom scroll bar as well as a side scroll bar? Thanks again for all the help!

 

[Norie]

Change the ColumnCount property of the control to 5 and set the column widths using the ColumnWidths property.

They should both be available when you right click the control and select Properties.

 

[Michael515]

Awesome, that was fairly easy haha. Thanks again!