Thread: Checkbox To Enables or Disables a Button in Userform

Try the attached. I've added code to the click events of Box1 and Box9 as well as to the buttons for each box

I moved the opening of the form from the Open event to the BeforeClose event.

Thx for the help.
I managed to finish the rest and tested it out and attached it here.
All works fine except 1 button can't perform the command its assigned to because of the code in this workbook:

Code:

Private Sub Workbook_Before Close(Cancel As Boolean)
    Confirm1.Show
    'When button "Co Back to workbook" is clicked in the Confirm1 Form
    'this workbook.close needs to be canceled so I can go back to to the workbook.
End Sub

So I got a commandbutton1 in the Confirm1 Userform that is assigned with:

Code:

Private Sub CommandButton1_Click()
    Confirm1.Hide
End Sub

When I push this button the workbook closes because its still in the 'Private Sub Workbook_BeforeClose' code.

Is there a way to cancel that code? Something like this?

Code:

Private Sub CommandButton1_Click()
       Confirm1.Hide
       Workbook.close Cancel
End Sub

Thx