Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel vba courses - IT
|
|
|
The UK's most regular 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 vba courses - IT
Resolved · Low Priority · Version Standard
Reply Wed 14 Nov 2007, 16:15Delegate David said...
For upcoming training course dates see: Pricing & availability
Reply 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
|