ExcelBanter - ListBox with non contigous columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - ListBox with non contigous columns (https://www.excelbanter.com/excel-programming/356777-listbox-non-contigous-columns.html)

François

ListBox with non contigous columns

Hello,
I'm trying to display on a listbox 3 columns (A1:B100 & E1:E100). On can I
achieved this using the ListBox.Rowsource ?

Thanks.

François

Martin

ListBox with non contigous columns

Another way is to use ListBox.AddItem in a loop scrolling through the cells.

"François" wrote:

Hello,
I'm trying to display on a listbox 3 columns (A1:B100 & E1:E100). On can I
achieved this using the ListBox.Rowsource ?

Thanks.

François

All times are GMT +1. The time now is 01:52 AM.