Forum home » Delegate support and help forum » Microsoft Excel Training and help » 2002 excel microsoft training - Custom Function 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. |
2002 excel microsoft training - Custom Function Macros
Resolved · Low Priority · Version Standard
Reply Fri 14 Dec 2007, 18:01Delegate Hari said...
Hari has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Custom Function Macros
How to create a custom function Macros?.
For upcoming training course dates see: Pricing & availability
RE: Custom Function Macros
Hi Hari
It was great having you on my Excel Course on Friday. Hope you had a good weekend.
To create a Custom Function
1. Tools menu, Macros, Visual Basic Editor
2. Insert menu, Module
3. Write the word 'Function' to mark the beginning then write your function name with it's arguments.
e.g. Function MyFunction (sales2000, sales 1999)
4. Write the Function Name and then write the code for the function
e.g. MyFunction = (sales2000 - sales1999) / sales1999 * 100
5. 'End Function' should mark the end of the Function
6. Save the Function and return to your Excel worksheet.
7. To use your new function either select a cell and type it directly or use the Function Wizard, selecting the category 'User Defined'.
Hope this helps
Sandy
|