Skip to: Site menu | Main content


Remember me?

Creating UDF's

written by Mark Rowlinson - Last updated Dec 2006

You write functions by adding a module to a project and creating a public function:

Public Function MyFunctionName(ArgList As Type) As Type 
End Function 

You'll notice that to return the result you asign the value you wish to return to the function name. This is the same as for any function in Visual Basic. For example a simple function that add's 1 to a value would be:
Public Function AddOne(Value As Single) As Single 
End Function 

You can pass any type of data to the function depending on the type of data that you require. For instance if you are working with dates you could have a function:
Public Function 1DayLater(DateValue As Date) As Date 
End Function 

You can also accept an excel range as an argument. For example the above function could be rewritten as:
Public Function 1DayLater(DateRange As Range) As Date 
End Function