Question

Background: This assignment covers Macros. Macros are a pretty advanced Excel tool. You may only see these at places you work depending on who is the Excel Wizard. It is essentially a way of making your redundant tasks done with the simply click of a button. For this example you will simply be recording random macro and pasting a random name with formatting of your choice in an Excel spreadsheet.

Objectives: Record a macro. Discuss the process of creating a macro and its uses. Instructions: Create your own file. Create a new Excel Spreadsheet. Record a Macro that will write a random name in a cell of your choice. Create a text box on that Excel spreadsheet detailing the steps you took to record the macro. You will want to describe what cell you told it to go in, the formatting, and the color.

Answer 1

Macros are advanced excel which is related to programming. With macros, we can define customized features to meet the needs of an organization. Since it is not possible for naïve user to write code and to automate repetitive actions, we do have an option called recording a macro. With this option, whatever the user performing in an excel sheet being recorded and converted into code. The end user just needs to play the macro to do the repetitive task.

To record a macro, we need to have “Developer” tab option enabled in Excel. The steps to record a macro is given below:

1. Go to “Developer” tab.

2. Under “Code” category of “Developer” tab, select “Record Macro” option.

3. Once you click on “Record Macro” option, the window pops up. Enter the name of the macro, need of macro in the Description, you can also define your own shortcut key for the macro. You can just press this shortcut key.

4. Perform your actions. In this case, I entered “Hello World” in the cell. Added background color and changed the text to bold.

5. After completing the task, go to “Developer” tab again and click on “Stop Recording”

6. Click on “Macros” and select “Testing” macro which was created. Click on “Edit” this would take you to code.

7. You can see the code has been recorded for each action in a procedure.

Sub Testing()

'

' Testing Macro

' Testing the macro

'

' Keyboard Shortcut: Ctrl+Shift+T

'

    ActiveCell.FormulaR1C1 = "Hello World"

    Range("A1").Select

    Selection.Font.Bold = True

    With Selection.Interior

        .Pattern = xlSolid

        .PatternColorIndex = xlAutomatic

        .Color = 65535

        .TintAndShade = 0

        .PatternTintAndShade = 0

    End With

End Sub

Please do comment for any queries please