initial value of checkbox

ankethaton

New Member
Joined
Dec 28, 2005
Messages
5
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.
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

mortgageman

Well-known Member
Joined
Jun 30, 2005
Messages
2,015
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
 

Watch MrExcel Video

Forum statistics

Threads
1,119,264
Messages
5,577,081
Members
412,763
Latest member
sienweiw
Top