+ Reply to Thread
Results 1 to 2 of 2

Usage of standard functions into custom function (or user defined function)

  1. #1
    Registered User
    Join Date
    05-13-2016
    Location
    USA
    MS-Off Ver
    2010
    Posts
    1

    Usage of standard functions into custom function (or user defined function)

    I am using Microsoft excel 2010. I created my own customized function(or user defined function (UDF)).
    I need to use existing function into UDF.
    e.g.
    Function MULTIPLYS(X As Variant, Y As Variant) As Long
    MULTIPLYS = X * Y *2
    MULTIPLYS = MOD(MULTIPLYS,2^16) 'need to use excel inbuilt function
    End Function

    Is it possible to use in-built excel function into UDF?
    If yes then do we need to provide path of MOD excel function?
    In above example, I am getting error"Compiler Error : Sub or Function not defined"

    Thanks in advance.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,789

    Re: Usage of standard functions into custom function (or user defined function)

    You can use VBA MOD() function instead of worksheet MOD()

    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] User defined function returns an error on a standard function used in it.
    By pb48 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-23-2013, 01:35 PM
  2. Adding user defined functions to standard categories
    By avr5iron in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-03-2009, 04:44 PM
  3. Excel 2007 error when adding custom help file to user defined function
    By sabotuer99 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-04-2009, 01:10 AM
  4. User Defined Functions & Function Combos
    By nsorden in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-04-2009, 11:03 AM
  5. [SOLVED] Excel - User Defined Function Error: This function takes no argume
    By BruceInCalgary in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2006, 04:05 PM
  6. i cant see my user defined functions in function list
    By delmac in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-11-2006, 05:30 AM
  7. [SOLVED] Custom Format for User Defined Function
    By brett.kaplan@gmail.com in forum Excel General
    Replies: 5
    Last Post: 08-07-2006, 06:30 PM
  8. Insert Function wizard for User Defined Functions
    By NBC in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-14-2005, 04:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1