sort and filter for userform listbox

[Martel]

I am sorting worksheet by 2 columns alphabetically then filtering by a 3rd which is required to be “Yes”. Works fine on worksheet but list box on user form returns all records regardless of 3rd column - could be blank or ‘No’. Userform containing List box is based on sorted and filtered worksheet. What could I be doing wrong. Help please

 

[sijpie]

Hi Martel,

are you using VBA to populate your listbox? Or are you just setting the range?
As far as I know that last one won't work.

If you are not using VBA at all, I suggest to use an advanced filter. Here the output can be sent to a separate range, which can then be used as input for the listbox.

If you are using VBA anyhow, then you add the items to the listbox one looping through the filtered table and using the
<code>.Range("D7:D46").SpecialCells(xlCellTypeVisible)
property. Do a search on google on : listbox from filtered list
</code>