Forum home » Delegate support and help forum » Microsoft Excel Training and help » MACROS
|
|
|
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. |
MACROS
Resolved · Medium Priority · Version 2010
Reply Tue 6 Sep 2011, 13:00Delegate Kate said...
Kate has attended:
Excel Introduction course
Excel Intermediate course
MACROS
I would like to take a macro and update it, but I've never worked with MAcros in the past. Is it possible to update a marco, or must they be started from scratch? Basically I would like to run a macro to calculate foreign exchange rates.
For upcoming training course dates see: Pricing & availability
RE: MACROS
Hi Kate,
Thank you for your question and welcome to the forum.
You could certainly record a macro to convert currencies. However to edit the macros you would have to know how to create and edit VBA code.
The VBA code is automatically written as you are recording the macro in the front end.
Please find the link below on how to record macros:
http://www.addictivetips.com/microsoft-office/how-to-create-a-simple-macro-in-excel-2010/
I hope this helps.
Regards
Simon
Fri 16 Sep 2011: Automatically marked as resolved.
|