Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I have 10 checkboxes with names chkParams1, chkParams2,...,chkParams10. I am writing a sub to reset these boxes using a control box. I could simply put the statement: Sheet11.chkParams1.Value = False ..... for all of the boxes. But I am wondering if there is a better way using a for loop. How do I make the checkbox name dynamic so that I can do the following: Private Sub btnResetConst_Click() Dim i As Integer For i = 1 To 14 Sheet11.chkParams???.Value = False next i End Sub Thanks, pac |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
problem with checkbox control | Excel Worksheet Functions | |||
how do I protect a worksheet and still use a checkbox control | Excel Worksheet Functions | |||
Setting LinkedCell on a CheckBox Control | Excel Programming | |||
Taking focus off a Control Checkbox | Excel Programming | |||
VBA Control Checkbox | Excel Programming |