Custom functions

Hi Arjuna,

Thank you for your question.

In order to create a Custom function in VB, go to the Visual Basic Editor (Alt+F11).

Create a new module and type Function followed by a space and the name of the function. Open brackets and enter the arguments possibly using the column headings (no spaces between words in each heading) of the figures separated by a comma.

Next line, type your function name followed by an equals sign and in brackets define what the function will actually do. Then end the function.

I hope this answers your question.

Simon