Hari has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Custom Function Macros
How to create a custom function Macros?.
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
