If you have an old version of your workbook, maybe you could try this (I think
I'm remembering it correctly)...

If you have a linked cell for that listbox, make sure it's on a different
worksheet.
If you have the listfillrange on the same worksheet, put it on a different
worksheet.

Another option would be to drop both the linkedcell and listfillrange and use
code to populate the listbox and assign the value to a cell.

wrote:

I think i've found a way around this. I've stopped using Listboxes.
Instead i'm using ComboBoxes that i've changed into effective dropdown
lists. They seem to be a lot more stable than the Listboxes.

It solves the problems for just now anyway.

--

Dave Peterson