excel xp training - macros

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel xp training - Macros

excel xp training - Macros

resolvedResolved · Low Priority · Version Standard

Janet has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course

Macros

How to build a basic macro

RE: Macros

A Macro is simply a way to automate a procedure.

To give you an example, click in an empty cell in excel, then go up to the Tools Menu and down to Macro> Record a New Macro.

You can give the Macro a name you can use your own name,

then type your last name into the cell, press enter, (so your cell is not active) and go up to the Tools menu and down to Macro>Stop Recording.

If you go into Tools>Macro>Macros and click on your name and then press Run the computer should automatically type you own name in a cell.

Now you have created an automated procedure and simply put, you can record all different types of routine procedures.

If you have any problems with that let me know

Tracy


 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

How to Spell Check an Excel 2010 Worksheet

Excel 2010 does not automatically spell check a document. So, here's how to manually spell check a worksheet.

Either select the ''Review'' tab in the Ribbon, go to the ''Proofing'' section and click ''Spelling.'' Or, simply press F7.

View all Excel hints and tips


Server loaded in 0.1 secs.