Udateing list on a Worksheet listbox

[fraz627]

I have a listbox that the data comes from cells on a worksheet.

I know this is simple but can't seem to make it work.

I would like to when the cells are filtered, redisplay on the filtered items basicly I can't seem to re-set the listrangefill property, it is initally set in the properties sheet.

thanks

[JosephP]

the listfillrange will ignore filtering so you would require code to populate the listbox by looping through the visible cells

[fraz627]

After filtering, I copy the filtered data to another range which ignores the hidden rows. but I can't re-set the listrangefill property.

[JosephP]

why not? what have you tried and what happened?

[fraz627]

I've tried various formats, Sheets("data").listbox2.listrangefill="a1:g20"
also sheets("data").listbox2.controlsource.listrangerfill= "a1:g20"
these are example for the help files

[JosephP]

it's listfillrange but is it a forms listbox or activex one?