Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
Chapter 32. Getting Started with VBA > Reading and Editing Your Recorded VBA Co...
Reading and Editing Your Recorded VBA Code
The best way to get started with the Visual Basic Editor is to record a macro, and then to study the code you've recorded. For example, you can record a macro that adds a place for your signature to the end of any document. Follow these steps to record the macro:
Open a document to use as a test document while you are recording the macro.
Double-click the REC button on the status bar. The Record Macro dialog box appears.
Type Signature as the macro name, and click OK.
Press Ctrl+End to move to the end of the document.
Press Enter twice to add a paragraph and a blank line.
Type Sincerely, then press Enter four times.
Type your name, and press Enter.
Press Ctrl+I to turn on italic.
Type your title, then press Ctrl+I to turn off italic.
Press Enter to add another paragraph.
Double-click the REC button on the status bar to turn the macro recorder off.
