excel vba courses - it

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 vba courses - IT

excel vba courses - IT

resolvedResolved · Low Priority · Version Standard

David has attended:
Excel Introduction course

IT

What are macros?

RE: IT

a macro is basically a 'recorder' that records everything you do whilst you are making a macro. It's useful for tasks that have to be done many times, such as sorting a list daily.

go to tools > Macro > record new Macro and do some stuff like move from sheet 1 to sheet 2


then press stop on the macro recorder.

Now, go back to sheet 1 and go tools > macro > macros

select the name of the macro you just made and it will take you from sheet 1 to sheet 2.

This can now be attached to a button thru the drawing toolbar and you can use that button to move to sheet 2.

Hope this helps

Paul

 

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:

Add Text to Displayed Numbers in Excel 2010

To add text to a number in a cell, you need to go to the Home tab on the Ribbon, and click on the Cells group. Select Format Cells from the drop down menu then Custom from the Category list. In the Type box select General. After the word General, enter a space, then opening quotation marks, then the word you want to type and then closing quotation marks. Click on OK and you have your text!

View all Excel hints and tips


Server loaded in 0.08 secs.