+ Reply to Thread
Results 1 to 3 of 3

learning U.D.F and how to write the code

  1. 04-08-2014, 10:57 AM #1
    andy_tap
    andy_tap is offline
    Registered User
    Join Date
    04-08-2014
    Location
    Oz
    MS-Off Ver
    Excel 2013
    Posts
    63

    learning U.D.F and how to write the code

    Hello

    I need help understanding reading and writing U.D.F

    What is the ideal way to learn a basic U.D.F code like below
    What is the xxx & nnn in the formula?
    I am not understanding how the code below works

    Please Login or Register  to view this content.
    Thanks
    Reply With QuoteRegister To Reply
  2. 04-08-2014, 11:07 AM #2
    apo
    apo is offline
    Valued Forum Contributor
    Join Date
    03-22-2013
    Location
    Australia,NSW, Wirrimbi
    MS-Off Ver
    Excel 2013
    Posts
    1,057

    Re: learning U.D.F and how to write the code

    Probably others can explain it better.. but ..

    nnn is the string that is passed to the Function... like "=Backwards(apo)".. bad choice.. i know..

    xxx is the result..
    Reply With QuoteRegister To Reply
  3. 04-08-2014, 11:33 AM #3
    Tinbendr
    Tinbendr is offline
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: learning U.D.F and how to write the code

    Maybe this will help. 
    Please Login or Register  to view this content.
    Also, the value passed in your example has to be a literal, unless it is a cell reference.
    =Backwards("APO") or =Backwards(C1)


    I don't know if this is just an exercise, but VBA has a built-in function for this.

    Please Login or Register  to view this content.
    Last edited by Tinbendr; 04-08-2014 at 11:36 AM.
    David
    (*) Reputation points appreciated.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Code Problem: How to Write this into a VBA code
    By rlkerr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-28-2013, 02:46 AM
  2. [SOLVED] IF Exists or on Error Then - Skip Code- How to write code?
    By Jack7774 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2013, 06:45 PM
  3. Learning VBA - Suggestion for Beginners Learning Curve
    By sighlent1 in forum Excel General
    Replies: 1
    Last Post: 08-26-2010, 12:58 PM
  4. Code to write out all lines of code
    By davidm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-04-2005, 11:26 PM
  5. Learning Excel VB Code
    By Josiah in forum Excel General
    Replies: 2
    Last Post: 05-02-2005, 02:58 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1