Chapter 12 Quick Reference

Chapter 12 Quick Reference

To	Do this
Process objects in a collection	Write a For Each…Next loop that addresses each member of the collection individually. For example: Dim ctrl As Control For Each ctrl In Controls ctrl.Text = "Click Me!" Next
Move objects in the Controls collection from left to right across the screen	Modify the Control.Left property of each collection object in a For Each…Next loop. For example: Dim ctrl As Control For Each ctrl In Controls Ctrl.Left = Ctrl.Left + 25 Next Ctrl
Give special treatment to an object in a collection	Test the Name property of the objects in the collection by using a For Each…Next loop. For example: Dim ctrl As Control For Each ctrl In Controls If ctrl.Name <> "btnMoveObjects" Then ctrl.Left = ctrl.Left + 25 End If Next
Create a new collection and add members to it	Declare a variable by using the New Collection syntax. Use the Add method to add members. For example: Dim URLsVisited As New Collection() URLsVisited.Add(TextBox1.Text)
Use Visual Basic for Applications collections in Office applications	Open Word or another Office application (Excel, Access, PowerPoint, and so on). Click the Macros command on the Macro submenu of the Tools menu, give the macro a name, click Create, and then enter VBA macro code by using the Visual Basic Editor. Word exposes many useful collections, including Documents and Paragraphs.