Check boxes checked

I was just wondering if it was possible to have a user form with check boxes that, after it is closed and reopened, the check boxes are still checked to show what options were chosen by the user. If this is possible, how would someone go about implementing this? I am using Excel 2007 and I don't have an example because it is just something I thought of.

Thanks in advance.

One way is to put a value in a spare Cell Toggle the caption with the checkbox value.

When the form is Initialized, set the check box to the Cell value
i.e.

Please Login or Register  to view this content.

Hope this helps.

If you need any further information, please feel free to ask further

However

If this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody!
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.