+ Reply to Thread
Results 1 to 2 of 2

vba message box inquiry

  1. 10-20-2014, 09:59 AM #1
    UMBiii
    UMBiii is offline
    Registered User
    Join Date
    02-04-2014
    Location
    Baltimore, Maryland
    MS-Off Ver
    Excel 2010
    Posts
    17

    vba message box inquiry

    I am using a vlookup formula in a column to check to see if there are any missing links of data in another file. If the vlookup returns the not available/error value #N/A, then I want a message box to display the information in the corresponding column of that row.

    For example, the values being vlookuped are in column A and my vlookup formula is in column L. If cell L3 = #N/A I want the message box to display the value in cell A3, but I want the message box to check all the errored values and present them all together one time.
    Reply With QuoteRegister To Reply
  2. 10-20-2014, 12:24 PM #2
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: vba message box inquiry

    Hello UMBii,

    To display all the error codes in a single dialog box will require writing a VBA macro. This may cause you a problem depending on the number of formulas you are using.

    VBA can not "see"a formula's result after it calculates. The user would have to run the macro manually or click a button to run the macro after the calculations are completed.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)
    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. Countif inquiry
    By cartica in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 08-23-2013, 06:08 PM
  2. Scheduling Inquiry
    By gum605 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-17-2012, 05:55 PM
  3. IF Formula Inquiry
    By Mrgbolee in forum Excel General
    Replies: 3
    Last Post: 10-22-2010, 08:26 PM
  4. Formula Inquiry
    By lilsnoop in forum Excel General
    Replies: 5
    Last Post: 04-02-2007, 09:59 PM
  5. VLOOKUP inquiry
    By Duley in forum Excel General
    Replies: 2
    Last Post: 06-23-2006, 10:37 AM

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