ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Passing a list to an array (https://www.excelbanter.com/excel-programming/371011-passing-list-array.html)

Matt[_41_]

Passing a list to an array
 
Just curious to know if it is possible to convert a listbox of values
to an array, such as:

Dim arrA as variant
with me.listbox1
arrA = array(.list)
end with

Seems like functionality that would make sense.
It's a pain to do the for i = 0 to .listcount - 1 thing to
create an array.

TIA,
Matt



All times are GMT +1. The time now is 12:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com