+ Reply to Thread
Results 1 to 9 of 9

auto next two functions

  1. #1
    Registered User
    Join Date
    09-29-2015
    Location
    Chicago
    MS-Off Ver
    2013
    Posts
    5

    auto next two functions

    I have noticed that I type a lot of iferror(vlookup(X,....) function in my daily work. Can i create a custom function that auto types those two together or does the same thing as those two. For example if I were to name the new function QuickV lets say then when I type QuickV and hit tab then it auto fills in the function iferror(vlookup( at which point I start to type in the arguments of the Vlookup and Iferror functions as needed? Not the greatest at VBA. Sample code would be great if this type of functionality is possible in excel 2013. Thanks in advance.

  2. #2
    Forum Contributor
    Join Date
    08-07-2015
    Location
    AB, Canada
    MS-Off Ver
    Excel 2013 x64
    Posts
    132

    Re: auto next two functions

    I don't think there's a way to do what you're describing...

    If you only want to type the formula =vlookup(X,...) then the following macro will automatically place the =iferror(____________,"") around the existing formula. You could add it as an add-in and create a custom key-bound shortcut or ribbon shortcut. Then you'd only have to type your vlookup formula and click one button.

    Please Login or Register  to view this content.
    Let me know if that helps...

  3. #3
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: auto next two functions

    Have you explored using AutoCorrect?
    • File.Excel_Options.Proofing tab...AutoCorrect options
    ...Replace: QuickV
    ...With: =IFERROR(VLOOKUP(
    ...Click: Add

    Now, if you select a cell and start typing "quickv"..then any character or a space...Excel will change it to "=Iferror(Vlookup("


    Is that something you can work with?

  4. #4
    Registered User
    Join Date
    09-29-2015
    Location
    Chicago
    MS-Off Ver
    2013
    Posts
    5

    Re: auto next two functions

    I will try both. Thanks guys.

  5. #5
    Registered User
    Join Date
    09-29-2015
    Location
    Chicago
    MS-Off Ver
    2013
    Posts
    5

    Re: auto next two functions

    I ended up using the proofing options. This way when I send the file or others open it they don't have to enable macros and what not. Thanks guys. I will be using this functionality many times over!!!

  6. #6
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: auto next two functions

    Glad you got something you can use!

    Please confirm that the AutoCorrect edits you make actually get transferred to the other person's PC. (I'm not sure if they do)
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  7. #7
    Registered User
    Join Date
    09-29-2015
    Location
    Chicago
    MS-Off Ver
    2013
    Posts
    5

    Re: auto next two functions

    when I do it replaces the text with the text that I want =iferror(vlookup( then I hit the End key to position my cursor to the end of the text, then I select all the arguments of the vlookup then the arguments of the iferror function and hit enter. The text now in the field is as if I typed both functions manually like I was doing before I requested help. I would hope that is the way it transfters over since the proofing is local setting vs a file setting (unless I am wrong on this).

  8. #8
    Forum Contributor
    Join Date
    08-07-2015
    Location
    AB, Canada
    MS-Off Ver
    Excel 2013 x64
    Posts
    132

    Re: auto next two functions

    It sounds to me like you shouldn't have any problems across computers.

  9. #9
    Registered User
    Join Date
    09-29-2015
    Location
    Chicago
    MS-Off Ver
    2013
    Posts
    5

    Re: auto next two functions

    Tried it out across computers. Worked like a charm. I even went so far to use another auto-correct for the arguments of the iferror to make it even simpler

+ 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. Auto-update functions
    By pixie359 in forum Excel General
    Replies: 1
    Last Post: 06-07-2010, 09:33 AM
  2. Auto Functions/Template
    By Melissa75 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-14-2007, 03:48 PM
  3. Auto Date and Time functions
    By aletoconstco in forum Excel General
    Replies: 1
    Last Post: 10-11-2006, 06:01 PM
  4. auto archiving functions
    By torpido in forum Excel General
    Replies: 4
    Last Post: 10-10-2005, 03:05 PM
  5. [SOLVED] Auto repeate parts of functions
    By [email protected] in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM
  6. Auto repeate parts of functions
    By [email protected] in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  7. Auto repeate parts of functions
    By [email protected] in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 AM
  8. Auto repeate parts of functions
    By [email protected] in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM

Tags for this Thread

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