Store the values in a hidden sheet would be my reccomendation. Each time a
change is made to the check boxes update the values in the hidden sheet. When
you open the workbook use the on onen event in ThisWorkbook to initailize the
check boxes.
--
HTH...

Jim Thomlinson


"p. panter" wrote:

I have some CheckBoxes and I would like to remember which CheckBox was pest
when I start the Excel Sheet again, but I always get empty CheckBoxes.

How can I let the CheckBoxes know which one was selected.

Many thanks in advance.