Complete Word

Another way to increase the speed of writing VBA procedures in the Code window is with the Complete Word feature. As you enter the first few letters of a keyword and click the Complete Word button ^tj on the Edit toolbar, Visual Basic will save you time by completing the keyword entry for you.

For example, enter the first three letters of the keyword DoCmd in the Code window, and click the Complete Word button on the Edit toolbar:

Visual Basic will complete the rest of the command you started, and in the place of DoC you will see the entire instruction, DoCmd.

If there are several VBA keywords that begin with the same letters, when you click the Complete Word button on the Edit toolbar Visual Basic will display a pop-up menu listing all of them. To try this, enter only the first three letters of the word Application, press the Complete Word button on the toolbar, and select the appropriate word from the pop-up menu.

0 0

Post a comment