What would be the best technique for populating a list box using a array
D Dick Kusleika May 13, 2004 #2 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
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
