If you want to keep the checkbox value each time you change it, you
could define names to store the values and hide them.

Names.Add Name:="Storevalue1", RefersTo:=value

Next time you open the form, read values from the name with:

checkbox1.value = [Storevalue1]

Regards.


--
dbarelli
------------------------------------------------------------------------
dbarelli's Profile: http://www.excelforum.com/member.php...o&userid=31275
View this thread: http://www.excelforum.com/showthread...hreadid=509423