The default action for controls is to unload from memory all property values
upon closing which includes closing a workbook. As Noob pointed out, they
can be reloaded automatically with the workbook open event or in the
initialize event of a form where applicable. However, to reload them with
the workbook open event, they would have to be saved in a file somewhere or
be calculated from data that is saved in a file and loaded with AddItem..

"Paolo Sardi" wrote:

Hi,
I'm working with a ListBox embedded in a worksheet. I noticed that, saving
and closing the workbook, the content of my ListBox is not saved. Is there a
way to make Excel preserve the content of my ListBox?

Thank you.