98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel vba courses - IT
excel vba courses - IT
Resolved · Low Priority · Version Standard
Wed 14 Nov 2007, 16:15Delegate David said...
Wed 14 Nov 2007, 16:50Delegate Paul said...
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 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Add Text to Displayed Numbers in Excel 2010To 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! |
