Unsaved Actions in List Boxes (Excel 2003)

Hello,

I'm having trouble with list boxes in Excel 2003. I have created several list boxes for which I need a shared group of users to be able to mark as the complete the actions. My problem is that the users' actions are not being saved as they close the file.

The only reason I have the list boxes is so users can see what options they have for sharing information. In other words, I do not need to know that 14 people chose X or 23 people chose Y. I only want users to be able to mark off where they've shared information and to see where else they might want to share it further.

Please let me know if any of that is not clear. I really appreciate any help you can offer on this subject. I've searched and searched for a reason for this. I have a short term solution with using single check boxes rather than list boxes, but the single check box option is much more cumbersome to deal with.

If you want to save the selections in the listboxes, you need to save them somewhere - probably in the cells of a worksheet.

Once the file is opened, you should check the cells and write the values back to the listbox.

No controls will save their states once the workbook is closed