Recording macros in Excel



1
How do you record macros in Excel??

3 Answer(s)


0

Do you have common tasks that you perform over and over in Microsoft Excel 2000? For instance, do you often apply the same combination of formats, or do you receive data every week or month that you organize and analyze the same way every time? You can use a macro to combine all of the steps in a task into a single command.

A macro records your mouse clicks and keystrokes while you work and lets you play them back later. You can use a macro to record the sequence of commands you use to perform a certain task. When you run the macro, it plays those exact commands back in the same order, causing Excel to behave just as if you had entered the commands yourself.

Macros are easy to create: you tell Excel to start recording, perform actions as you normally do, and then tell Excel when you're done. Behind the scenes, Excel uses a programming language called Visual BasicĀ® for Applications (VBA) to record your instructions. You don't have to know anything about programming or VBA to create and use macros that will save you time and make your work easier.

This article shows you how to create and use a simple macro that formats a cell, then change this macro to make it do even more. It also explains your options for storing macros so that you can use them from any workbook.

Applying formats is a fairly simple macro example, but you can record macros to do more complex tasks like retrieving and filtering external data, creating and customizing charts, and more.

Simplify frequent chores: record a simple macro
Let's say you work in a group that uses Excel to track accounts receivable. Every week you and your co-workers each submit a report in which your manager expects to see overdue amounts formatted so that they're easy to see: the numbers are bold and red and the cells have red borders. Here's how to record a macro to apply these formats:

In the workbook where you track your accounts receivable, click one of the cells you're going to format.
Point to Macro on the Tools menu, and then click Record New Macro.
In the Record Macro dialog box, type a name for the macro in the Macro name box. Macro names must start with a letter and can include letters, numbers, and underscore characters, but can't include spaces. You don't need to change the other boxes

0

Do you have common tasks that you perform over and over in Microsoft Excel 2000? For instance, do you often apply the same combination of formats, or do you receive data every week or month that you organize and analyze the same way every time? You can use a macro to combine all of the steps in a task into a single command.

A macro records your mouse clicks and keystrokes while you work and lets you play them back later. You can use a macro to record the sequence of commands you use to perform a certain task. When you run the macro, it plays those exact commands back in the same order, causing Excel to behave just as if you had entered the commands yourself.

Macros are easy to create: you tell Excel to start recording, perform actions as you normally do, and then tell Excel when you're done. Behind the scenes, Excel uses a programming language called Visual BasicĀ® for Applications (VBA) to record your instructions. You don't have to know anything about programming or VBA to create and use macros that will save you time and make your work easier.

This article shows you how to create and use a simple macro that formats a cell, then change this macro to make it do even more. It also explains your options for storing macros so that you can use them from any workbook.

Applying formats is a fairly simple macro example, but you can record macros to do more complex tasks like retrieving and filtering external data, creating and customizing charts, and more.

Simplify frequent chores: record a simple macro
Let's say you work in a group that uses Excel to track accounts receivable. Every week you and your co-workers each submit a report in which your manager expects to see overdue amounts formatted so that they're easy to see: the numbers are bold and red and the cells have red borders. Here's how to record a macro to apply these formats:

In the workbook where you track your accounts receivable, click one of the cells you're going to format.
Point to Macro on the Tools menu, and then click Record New Macro.
In the Record Macro dialog box, type a name for the macro in the Macro name box. Macro names must start with a letter and can include letters, numbers, and underscore characters, but can't include spaces. You don't need to change the other boxes

0

Macro is basically used in Excel to automate a task that needs to be performed repeatedly.

When you record a macro, Excel stores information about each step you take as you perform a series of commands. If you start recording a macro, it will remember everything you do within a program. You then run the macro to repeat, or play back the commands. When the macro is played, it will repeat everything you did while you were recording the macro.

STEPS TO RECORD A MACRO

1) Under VIEW tab,go to Macros and then click --> Record Macro.

2) A window will open. Type a name for the macro in the Macro Name text box.

3) Assign a Shortcut Key.

4) From the Store Macro In drop-down list, select where you want to store the macro: This Workbook, New Workbook, Personal Macro Workbook.

5) Type a description of the macro in the Description text box.

6) Click OK.

7) Perform the actions you want to record.

8) Choose Stop Recording.

Your Answer

Click on this code-snippet-icon icon to add code snippet.

Upload Files (Maximum image file size - 1.5 MB, other file size - 10 MB, total size - not more than 50 MB)

Email
Password