VBA Multiple Objects with 'With' Statement

Question

I have a check box that when checked multiple boxes are disabled on my form. Currently im using

With Me!Textbox
.Locked = True

Is there a method where I can list multiple objects within the With statement rather than writing out each time for every textbox

e.g.

With Me!Text1, Text2, Text3

Answer 1

It may be easiest to add something to the tag property to identify the relevant controls, "lock", say. Then you can iterate over the controls collection and lock anything with a tag set to "lock".