+ Reply to Thread
Results 1 to 2 of 2

Macro Dialog Box

  1. #1
    Registered User
    Join Date
    11-25-2015
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    2

    Macro Dialog Box

    Hi,

    I do have a a excel file where by in Columm O is the vendor full name,Columm P is short name of the vendor, & Columm Q is the vendor code so in order for me to key in my invoice entry to be uploaded in my accounting system the vendor code is very essential for me, so in the columm E is where i input on the vendor short name and i used =VLOOKUP(E2,$P:$Q,2,0) to link the short name with to automated get the vendor code so what i wanted is can there be any pop up dialog box or notification appear the full name of the vendor once the vendor code is link to the cell so it can be a cross check reference for me to view my invoices entry is match with the vendor.Because sometime i may overlook and key in the wrong vendor short name so if there is a dialog box appear on every vendor entry i entered in excel it will ease my work.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Macro Dialog Box

    Hi,

    If the question is simply can I pick the short name from a list then I'd create a sorted list of your vendor names somewhere and name that range say "vendors", then create a validation drop down in E2, pick the list option and and enter
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Or perhaps you mean in say F2
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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. Put a dialog box in a macro
    By JOHNAK27 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-13-2013, 05:46 AM
  2. Find Macro with Dialog Box
    By KLT in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-27-2013, 10:39 AM
  3. Macro using file dialog opener - Cannot delete or rename folder when excel macro is
    By startrekremo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-15-2011, 01:57 AM
  4. [SOLVED] How to permanently change Dialog Caption while in the Dialog
    By MikeZz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2006, 01:35 PM
  5. [SOLVED] Dismiss a dialog box (Via a Macro)
    By msnews.microsoft.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-28-2005, 07:05 AM
  6. abort macro dialog box
    By Chris in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-04-2005, 05:06 AM
  7. [SOLVED] how to use the search dialog via a macro?
    By cyrille in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-18-2005, 10:06 AM
  8. Dialog box during long macro
    By brickc in forum Excel General
    Replies: 0
    Last Post: 01-04-2005, 05:39 PM

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