+ Reply to Thread
Results 1 to 2 of 2

How do I create a user-defined function in Excel 2011?

  1. #1
    Registered User
    Join Date
    06-22-2012
    Location
    New England
    MS-Off Ver
    Excel 2011
    Posts
    1

    How do I create a user-defined function in Excel 2011?

    Hate to post a question when the answer is probably obvious, but the Help system in Excel 2011 for Mac OS doesn't seem to work very well.

    I've finally gotten to a task for which I need to define a function, which I seem to need every couple of years or so, and... I'm stuck.

  2. #2
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: How do I create a user-defined function in Excel 2011?

    dpbsmith,

    You should be able to open the VBE (Visual Basic Editor) with Opt+F11. In the VBE, Insert -> Module. Then you can create your UDF.
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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