ExcelBanter - about using a function for more objects

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - about using a function for more objects (https://www.excelbanter.com/excel-programming/388507-about-using-function-more-objects.html)

Monte0682

about using a function for more objects

I have 5 checkboxes: checkbox1, checkbox2, etc...

I want to make a funtion

for i=1 to 5
checkboxi.enable=true
next

How to do this so I don't have to do
checkbox1
checkbox2
checkbox3
checkbox4
checkbox5

merjet

about using a function for more objects

For i = 1 To 5
Controls("Checkbox" & i).Enabled = True
Next i

Merjet

All times are GMT +1. The time now is 01:35 PM.