Fill listbox on form with filtered range

[deanrd]

I created a form with combo boxes to filter for info. Based on the 1st and last part of a serial number, it then filters the worksheet.

It updates the worksheet and shows the correct info I filtered for. How can I get this filtered info to a lsitbox on the same form.

Nothing I've tried will select the autofiltered range or assign it to a range name.

How can I get this info to display in a listbox.

I want the form to be the users only access.

Please help this dummy!

 

[Joe Was]

The only way I know of is to load the ComboBox, to a Sheet one row at a time on some column on some sheet, then select all the rows that have data and set the Bound Column property of the ListBox to that Column.