Michael515
Board Regular
- Joined
- Jul 10, 2014
- Messages
- 136
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!
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!