2002 excel microsoft training - 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