View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default Show checkbox checked on open

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.