Macros

Dear Alexis

Thank you for attending Excel 2007 Advanced course!! I hope you enjoyed the course and benefited from it.

Usually when you record any macros Excel writes VBA coding for it. If you want to know the coding for a macro that you may have created or someone else has created simply choose the Developer Tab on the Ribbon and in the Code Group choose Visual basic.


When the Visual Basic Editor appears on the screen you can see you macro in a special folder called Module.

Here you can either check the code or make some amendment. But if you want to make major modifications then you will need to have a good understanding of VBA.

Following is the link that provides the course detail such as course content a well as the schedule for the VBA courses. Please note that VBA courses are two day courses.

https://www.stl-training.co.uk/pages/courses/vba_training.shtm

Although the above link i for older versions but I am sure we have started running VBA for 2007 version.


I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007