initial value of checkbox

[ankethaton]

I have a button that resets my entire workbook (ie it deletes all user inputs). I also want this button to select all the checkboxes on my first worksheet called "Input Data"

How can I do it so that the value of all checkboxes (1 through to 11) is ticked (ie True)?

Thanks a lot.

 

[mortgageman]

Not tested, but something like this in your code (assumming that your checkboxes are named CheckBox1, CheckBox2, etc) should do the trick


Dim i As Integer
For i = 1 To 11
Me.Controls("CheckBox" & i).Enabled = True
Next i

Gene, "The Mortgage Man", Klein