Recording a Macro to Generate Code
TOC
Collapse the table of content
Expand the table of content

Recording a Macro to Generate Code

Office 2007

If you are unsure of which Microsoft 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 do not 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. For example, the following instruction 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.



Show:
© 2016 Microsoft