The method suggested does not require code. In the properties dialog box for
each checkbox there is a Control Source property. Select that property and
type in a cell reference e.g. Sheet1!a1. Of course use a different cell
for each checkbox, and choose a cell that will not be accesssed by users in
the normal course of business to avoid inadvertant changes. The chosen cells
will show True if the checkbox is checked and False if the checkbox is blank.
These cell values are retained after the userform is closed and are
automatically loaded into the checkbox when the userform is initialized again.

"Solution4U" wrote:

Could you show me an example of code for that? I am rather new to vba.

Thank you for the response.

"JLGWhiz" wrote:

You could probably set up a linked cell (control source) for each checkbox
which would hold the value of the checkbox until the form is reopened and
will show that value upon open.
"Solution4U" wrote:

I need help.

I have 3 userforms. Userform1 has 2 buttons, one to start a new project and
one that edits the project as saved. Which ever button is clicked brings up
userform2 which has 5 checkboxes.

What I would like to happen: when the edit button is clicked I would like
the checkboxes that were checked the last time to show up as checked. The
value of the checkboxes are stored on sheet3 in cells c2-c6.

Thank you for your time and assistance.