Microsoft Office Tutorials and References
In Depth Information
Discovering Code As You Go
When you convert a macro to VBA code, you actually convert all the macros
in the macro group to code. To perform basic conversion of a macro to VBA,
follow these steps:
1. Open the macro in Design view.
2. Click the (Macro Tools) Design tab and then click the Convert Macros
to Visual Basic button in the Tools group on the Ribbon, as shown in
A dialog box appears, asking whether you want to include error-handling
code or comments in the code. If you want to keep the code relatively
simple, you can clear the first option and select only the second option.
3. Click the Convert button.