Raw data consists of sample text data in "MainFile". When working with your own UDFs, the two things you are most likely to change in this line are the function name (NumXs) and the function result type (Integer). Step 3: Our end result should be either "Good" or "Bad," so the result should be in String. Using a User Defined Function (UDF) from another workbook using VBA in ... Click the 'Insert Function' option. Calling a User Defined Function (UDF).xlsm 23.5 KB Creating User Defined Functions (UDFs) End If End Function A UDF returns a value, typically from information passed into it as one or more parameters. In my example, I've called it FiscalYear. 3. User Defined Function in Excel VBA - Excel IF | No 1 Excel tutorial on ... [CODE] your code here [/CODE] "None of us is as good as all of us" - Ray Kroc "Actually, I *am* a rocket scientist." - JB (little ones count!) The normal phases of learning are: 1. User Defined Function in Excel VBA - Excel IF | No 1 Excel tutorial on ... Circles = Application.WorksheetFunction.Pi * r ^ 2. ' The following user-defined function returns the square root of the ' argument passed to it. Do it alone. The simplicity of of Excel VBA Function procedures (once they're created) is illustrated by the fact that, once the User-Defined Function (Function procedure) has been created, a regular user (only) needs to know the function's: Name; and Arguments. Add code to this file similar to the following: NAME MathLib. Following is the basic syntax. This enables the programmers to divide a big program into a number of small and manageable functions. 5. Next, we declare a Range object and call it cell. This eliminates the need of writing the same code over and over again. Microsoft MVP 2010 - Excel Visit: Jerry Beaucaire's Excel Files & Macros If you've been given good help, use the icon below to give reputation feedback, it is appreciated. excel - Calling a user defined Function in Sub VBA - Stack Overflow A function is a group of reusable code which can be called anywhere in your program. [CODE] your code here [/CODE] "None of us is as good as all of us" - Ray Kroc "Actually, I *am* a rocket scientist." - JB (little ones count!)