To Activities

IT 121 -- Activity A12

Excel Macros

Goal:   Learn how to record, modify and run macros.

1. Record a macro with name the FormatData and shortcut key Control-f. Enter some data and format in any way you wish. You must include at least four modifications, which can include:
   • Enter numbers or text in cells.

   • Change the font name.

   • Change the font size.

   • Change the font color.

   • Set the font to bold, italic or underlined.

   • Change the fill color of cells.

   • Change the fill pattern of cells.

   • Change the borders of cells, including the border line type and border line color.

2. Edit your macro. Make these modifications:
   • Replace each property FormulaR1C1 by the more understandable property Value.

   • Make any other modifications that you wish.

3. Test your FormatData macro:
   • Set all the cells in the worksheet back to their default values.

   • Run your macro by using the shortcut Control-f.

4. Record another macro named UnformatAll:
   • Set the shortcut key to Control-u.

   • Select all cells that were formatted by the FormatData macro.

   • Set to default values everything that was set by FormatData.

5. Edit UnformatAll:
   • Remove the first line that looks something like this:
     Range("A3:E9").Select

   • By removing this line, the macro acts on the selection that is chosen by the user before running the macro.

6. Test UnformatAll:
   • Run the FormatData macro.

   • Run the UnformatAll macro.

   • Verify that everything has been set back to default settings.