Use the Controls Collection

Use the Controls Collection

If you need to reference every control on a form, using the Controlscollection will be faster than referencing every control directly. Forexample, if you have four command buttons on a form and you want to setthe Enabled property to False for all of them, you have two options.
Option 1:

 cmdAdd.Enabled = False cmdEdit.Enabled = False cmdDelete.Enabled = False cmdNext.Enabled = False 

Option 2 will execute approximately 10 to 15 percent faster thanOption 1:

 For iLoop = 0 To 3 Controls(iLoop).Enabled = False Next 


Share the Post: