Array as Source for List Box

Coby · February 19th, 2008, 09:10 PM

Does anyone know if it is possible to set the row source for a list box to an array rather than a range of cells?

I am mainly trying to filter out certain rows from the list box.

I Access it is simple because an Sql query with a Where clause does the trick by committing a recordset much like an array to the list box.

I am not sure how to do this using the list box object in Excel, however.

I had also thought of just going with the range of cells rather than an array if I had to, then just running a loop to remove items from the list?

I tried both scenarios and have had no luck.

Thanks for sharing any knowledge you may have on this.

Coby.

tstav · March 24th, 2008, 05:43 PM

Hi Coby,
for what it's worth after a whole month from your post... put the following in the Userform code module.

Code:

Dim arr as Variant
arr = Array("AA","BB","CC")
ListBox1.List = arr

bum94587 · June 5th, 2013, 05:07 PM

Thanks, it works & saved me a lot of time!