custom functions

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Custom functions

Custom functions

resolvedResolved · Low Priority · Version 2003

Arjuna has attended:
Excel Advanced course

Custom functions

How do you create a custom function in Visual Basic for Excel?

RE: 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


Server loaded in 0.09 secs.