How to populate a list box using an array.

dovrox · May 13, 2004

What would be the best technique for populating a list box using a
array

Dick Kusleika · May 13, 2004

dovrox

Dim arr As Variant

arr = Array(1, 2, 3, 4, 5, 6, 7, 8, 9, 0)

Me.ListBox1.List = Application.Transpose(arr)

See also

http://www.dicks-blog.com/excel/2004/05/populating_acti.html#comments

Finding Text within an Array	2	May 30, 2013
Create Drop Down Box populated by a List	1	Dec 21, 2009
Array to Populate ListBox Problem	1	Jul 25, 2008
Filling a List Box in Excel from an Array	4	Oct 17, 2005
Referencing an array formula	2	May 26, 2009
Copying List box values/selection to a database of sorts	2	Jun 26, 2017
Combo box	2	Jul 3, 2009
How do I create a small array from a larger one?	3	Jul 24, 2009

Ask a Question