sharky12345
09-04-2015, 11:56 PM
I'm using this to populate a Listbox on a Userform;
Me.ListBox1.List = Sheets("Sheet1").Range("A5", Range("A100000").End(xlUp)).Value
Is there a way I can identify what Range the selected items refer to?
The range my not be contiguous as far as the row but will be in the same column and the Listbox is multiselect.
Posted elsewhere too;
http://www.mrexcel.com/forum/excel-questions/880621-get-range-listbox-selected-items.html
Me.ListBox1.List = Sheets("Sheet1").Range("A5", Range("A100000").End(xlUp)).Value
Is there a way I can identify what Range the selected items refer to?
The range my not be contiguous as far as the row but will be in the same column and the Listbox is multiselect.
Posted elsewhere too;
http://www.mrexcel.com/forum/excel-questions/880621-get-range-listbox-selected-items.html