Recording a Macro to Generate Code

If you are unsure of which Visual Basic method or property to use, you can turn on the macro recorder and manually perform the action. The macro recorder translates your actions into Visual Basic code. After you record your actions, you can modify the code to do exactly what you want. For example, if you don't know what property or method to use to indent a paragraph, do the following:

1. On the Developer ribbon, click Record Macro.

2. Change the default macro name to a name of your choice and click OK to start the recorder.

3. On the Home menu, click the Increase Indent button.

4. On the Developer ribbon, click Stop Recording.

5. On the Developer ribbon, click Macros.

6. Select the macro name that you assigned in Step 2 and click Edit.

View the Visual Basic code to determine the property that corresponds to the left paragraph indent (the LeftIndent property). Position the cursor within .LeftIndent and press F1 or click the Help button.

Remarks

Recorded macros use the Selection object. The following code example indents the selected paragraphs by one-half inch.

Sub IndentParagraph() 
    Selection.ParagraphFormat.LeftIndent = InchesToPoints(0.5) 
End Sub

You can, however, modify the recorded macro to work with Range objects. For more information, see Revising Recorded Visual Basic Macros.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.